View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alexm999[_82_] alexm999[_82_] is offline
external usenet poster
 
Posts: 1
Default Date Format Issue

I have a file that exports a date in the following format:
2003.12.30
2004.5.11

Its the year, month and then day. BUt I cannot use cell formating t
change the date format to:
Month/Day/Year

How can I do this using programming.
The data is always in column

--
Message posted from http://www.ExcelForum.com