Thread: convert 80521 to 05/21/08
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_807_] Rick Rothstein \(MVP - VB\)[_807_] is offline
external usenet poster
  
Posts: 1
Default convert 80521 to 05/21/08
If all your dates will be on or after the year 2000, try this formula...

=--TEXT(A1,"2000-00-00")

Rick


"KKay" wrote in message
...
Is there a formula that would convert 80521 to a date, 05/21/08?

Or convert a text of 080521 to a date format 05/21/08?

thx, k

Reply With QuoteReply With Quote