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

hhchavez - Mar 28, 2012 at 12:21 PM - 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 

4 replies

rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Mar 28, 2012 at 07:12 PM
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