View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How to remove the automatic date format?

Hi all,

I need help! When I type this: "01/08/2006" into the cell it
automatically changes into date format: "1/8/2006".

When I change it back to 'General' formatcellsnumber the cell changes
to "38725" .

How do I turn off the automatic date format, so that my cell will just
contatain "01/08/2006" without changing to the date format????

Thanks