Thread: How do I change my date from this format 20070507 to 05/07/07?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default How do I change my date from this format 20070507 to 05/07/07?
Those are probably not real dates. Use Data Text to Columns on the col of
dates. In step 3 of the wiz, check "Date" under "Column data format", then
select YMD from the droplist. Click Finish. Now you can format the real dates
to taste.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"SSA KO" wrote:
How do I change my date from this format 20070507 to 05/07/07? My Data
retrieval program puts my date in this format YYYYMMDD. I can't figure out
how to to change it to MM/DD/YY. Can any one help?
Reply With QuoteReply With Quote