Convert the date format into general format [Solved/Closed]

Report
-
 Bharath -
Hello,

In excel 2003, how do I convert the date (3/21/2012) from date format into general format and still keep it show as 3/21/2012 instead of 40989 in the cell?

thanks.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
You cannot. In excel dates are numbers. So when you choose general, it will not look like a date. So question is why you think you need to have a general format ?
acutally, I found my answer, I used this formula:
=TEXT(A2,"mm/dd/yyyy")

thanks.
use this code :
yourdate = 3/21/2012
=REPLACE(yourdate,1,0,"")

Answer :
40989