MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date conversion


Posted by windall bekker on October 22, 2001 6:15 PM

How do I convert the date type 20010101 in a yyyymmdd format to the text type "20010101" without converting it to a numerical value = 36892

Thanks guys & gals :)


Posted by Richard S on October 22, 2001 7:52 PM


There's probably an easier way, but if say you had all the dates in one column, you could copy that column to a new file, and save it as a text (Tab delimited) file, then close it. When you reopen it, it will contain 20010101, not a date
Any Help?
Richard

Posted by windall bekker on October 22, 2001 8:52 PM

thanks for the note. I did what you suggested and it worked but I was hoping to find a date function in Excel. anyways, have a nice day.

Posted by windall bekker on October 22, 2001 9:01 PM

thanks for the note. I did what you suggested and it worked but I was hoping to find a date function in Excel. anyways, have a nice day.

Posted by Aladin Akyurek on October 23, 2001 1:21 AM

The formula to convert a date to text would be

=TEXT(A1,"yyyymmdd")

However, one shot operation Richard suggested is more attractive than computing by means of the above formula.

Aladin

========