Thread: This date 20071017072917 into this type of date 10/17/2007 29:17
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default This date 20071017072917 into this type of date 10/17/2007 29:17
One way (assuming you really wanted 10/17/2007 07:29:17 rather than what
you posted):

=--TEXT(A1,"0000\/00\/00 00\:00\:00")

Format as mm/dd/yyyy hh:mm:ss

t

In article ,
Micro wrote:

How to convert This date 20071017072917 into this type of date 10/17/2007
29:17
Reply With QuoteReply With Quote