Thread: Convert test to date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GKW in GA GKW in GA is offline
external usenet poster
  
Posts: 68
Default Convert test to date
I have a cell, F5, that has 20071225 in it. I want to convert this to a date
field that displays as 12/25/2007

When I use the function =DATEVALUE(F5) , I get #VALUE!

Can you tell me how to do this without using substringing and concantenating

Reply With QuoteReply With Quote