Convert the date format into general format

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

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Mar 28, 2012 at 07:12 PM
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 ?
0
acutally, I found my answer, I used this formula:
=TEXT(A2,"mm/dd/yyyy")

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

Answer :
40989
0
Thank you
0