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? |
All times are GMT +1. The time now is 01:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com