Thread: Show numberic coded date as a proper date within format cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gerik von Graevenitz Gerik von Graevenitz is offline
external usenet poster
  
Posts: 1
Default Show numberic coded date as a proper date within format cells
Hello,

I have a date coded as a numeric value like 1131212, which is equivalent to 2013/12/12 or 1150313, which is equivalent to 2015/03/13. I want to display this coded date in human readable date format. Is it possible to transcode it without an additional cell using format/cell?

I could transform it with an additional cell like =TEXT(K5+19000000;"0000-00-00"), but I do not want to have a second cell to transform this special numeric date value.

Gerik
Reply With QuoteReply With Quote