Convert currency format to date format in excel

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


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


Check below for your reference


Hope this will help you


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


For Number to convert check below reference

Link to Number to Date

Hope this help you


Hi @dhanashree22
Use this syntax

Hi @dhanashree22

Can you please try this?

Hope this will be useful. Thank you.