Thread: Change text to date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gerrym Gerrym is offline
external usenet poster
  
Posts: 8
Default Change text to date
I have a column of cells with dates stored as text i.e.
041012 and I would like to convert this to 12/10/04
(dd/mm/yy) how do I do this, please
Reply With QuoteReply With Quote