Thread: How do I change an 8 digit reversed date number into a date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_5_] Sheeloo[_5_] is offline
external usenet poster
  
Posts: 248
Default How do I change an 8 digit reversed date number into a date
With the string in A1 use this in B1
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

-------------------------------------
Pl. click ''Yes'' if this was helpful...



"jrnbru59" wrote:

Example - to change 20090331 into 31/03/2009
Reply With QuoteReply With Quote