View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Change text to date

Hi

Select the cells. Go menu Data Text to columns. Go "Next" until you're in
the wizard's part 3, there select format Date, MDY (or DMY is that's what
you have) and click Finish.

HTH. Best wishes Harald

"Gerrym" skrev i melding
...
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