Thread: How do I change the date format in Excell from eg 20060926
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I change the date format in Excell from eg 20060926
dates eg: 20060926

Another way is to use Data Text to Columns. Select the col of "dates".
Click Data Text to Columns, click Next Next. In step 3 of the wiz, under
Col data format, check "Date" and select: YMD from the droplist next to it,
click Finish.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave" wrote:
Excell doesnt recognise the above format as a date, eg: 20060926
so I would like to change it, however the standard date formats dont work.
Reply With QuoteReply With Quote