Thread: Modify general format to date format.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Modify general format to date format.
=--TEXT(A1,"00-00-0000")


"SherryS" wrote:

When importing from payroll, it gives me all dates formatted as general
numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to
convert these numbers into dates?

Reply With QuoteReply With Quote