Thread: Need help with converting CUSTOM format/TEXT format to DATE format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deo Cleto Deo Cleto is offline
external usenet poster
  
Posts: 1
Default Need help with converting CUSTOM format/TEXT format to DATE format
A column in an excel file was formatted in CUSTOM format like 00-00-0000.
Whenever I changed the format to DATE (ex. 01-01-1901), it is changing to
06/27/4670 which is wrong. I changed the format to TEXT and it results to
1011901. I need a date format as mm/dd/yyyy so I can import this excel file
with the correct date format. Please help. Thanks.

Reply With QuoteReply With Quote