Thread: Help: How do I convert a text date into a real date format
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG SteveG is offline
external usenet poster
  
Posts: 1
Default Help: How do I convert a text date into a real date format

You could use this if your day value is always 2 digits (1st = 01,
2nd=02 etc..) So October 10 is 101006 and January 1 is 10106

=TEXT(A1,"00-00-00")*1

Format cells as mm/dd/yy.



HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=567496

Reply With QuoteReply With Quote