Convert date to text

Posted by Darren on July 11, 2000 10:41 PM

Hi guys!!!

Anyway for me to convert date to text. Currently, what i get is value of the date i.e 36162 for 1-Jan-99 instead of 1 January 1999. Any solution???

Thanks a lot lot lot

Regards,
Darren

Posted by Ada on July 12, 0100 1:46 AM

Anyway for me to convert date to text. Currently, what i get is value of the date i.e 36162 for 1-Jan-99 instead of 1 January 1999. Any solution???

Assuming your date is in A1, enter the following formula in some other cell :-

=TEXT(A1,"dd/mm/yy")

You can change the format "dd/mm/yy" to fit your requirement.

If you want to keep the date in cell A1 but change it so that it acts like text instead of like a date, enter an apostophe( ' ) in front of the date.
Alternatively, you can format the cell as text before entering the date.

Ada

Posted by Ada on July 12, 0100 2:15 PM

Anyway for me to convert date to text. Currently, what i get is value of the date i.e 36162 for 1-Jan-99 instead of 1 January 1999. Any solution???

Have a look also at the replies to Help - Concatenate Date posted by Bill on July 07, 19100 at 07:44:54

Ada