View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
macropod macropod is offline
external usenet poster
 
Posts: 329
Default Turn off Automatically convert number to date

Hi Ky,

Two options:
1. format the cell as text before inputting the data; or
2. input a tick mark (') as the first character.

Cheers


--
macropod
[MVP - Microsoft Word]


"Ky" wrote in message ...
| I have this problem where Excel turns a number into a date. Eg. when I input
| 7440-09-7, Excel turns it into 9/7/7440 which is not what I want. I image
| there is a setting that can turn this default behavior off. Can someone help
| me?? Thanks