Convert currency format to date format in excel

Help Studio
, ,
1

hello all, here I want the currency format convert into date format in excel .

2

Hi,

Could you pls share us sample so that would help you better. Thanks.

3

@dhanashree22

Check below for your reference

Link

Hope this will help you

Thanks

4

when I extract the date from cheque it gives 2 2 2 1 0 6 1 and actual date on cheque is 06/12/2021 . but when i write this date in excel. it print as same like 2221061 . how to
convert this currency into date format in excel

5

@dhanashree22

For Number to convert check below reference

Link to Number to Date

Hope this help you

Thanks

7

Hi @dhanashree22
Use this syntax
index.ToString.Substring(0,2)+“/”+index.ToString.Substring(2,2)+“/”+index.ToString.Substring(4,4)

8

Hi @dhanashree22

Can you please try this?

Hope this will be useful. Thank you.