Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date formating
Hi Jason,
Highlight the column containing the dates, select Data | Text to Columns..., click Next twice, then select the Date radio button and change the dropdown to YMD. Look the Data Preview to make sure it interprets your data correctly; if everything looks good, click Finish. Regards, Jake Marx MS MVP - Excel "Jason Trolian" wrote in message ... I have a spreadsheet that comes with the date formated like this (yyyymmdd - 20030910) The normal format cell function will not change that date to (mmddyy - 09/10/2003) any way I can do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formating a date | Excel Discussion (Misc queries) | |||
formating and date changes | Excel Discussion (Misc queries) | |||
Date Formating | Excel Discussion (Misc queries) | |||
Date Formating | Excel Worksheet Functions | |||
Date formating | Excel Discussion (Misc queries) |