Thread: Converting a date number?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell[_4_] Terry Pinnell[_4_] is offline
external usenet poster
  
Posts: 192
Default Converting a date number?
Claus Busch wrote:

=DATE(1970,1,1)+LEFT(A1,LEN(A1)-4)/86400

Excellent, thanks Claus!

Best wishes,

Terry, East Grinstead, UK
Reply With QuoteReply With Quote