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

- - Latest reply:  Bharath - Dec 12, 2013 at 06:53 AM
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.

See more 

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
0
Thank you
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