Convert currency format to date format in excel

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

Hi,

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

@dhanashree22

Check below for your reference

Link

Hope this will help you

Thanks

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

@dhanashree22

For Number to convert check below reference

Link to Number to Date

Hope this help you

Thanks

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

Hi @dhanashree22

Can you please try this?

Hope this will be useful. Thank you.