Previous Topic Next Topic

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.

Related:

1 response

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

thanks.
0
prakash
Feb 12, 2013 at 03:39 PM
use this code :
yourdate = 3/21/2012
=REPLACE(yourdate,1,0,"")

Answer :
40989
0
Bharath
Dec 12, 2013 at 06:53 AM
Thank you
0

Similar discussions

Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses
How can I publish a study that I have done on this website?
simonrasho -
Daniel_CCM -

1 response