Thread: I type in 1-2, how can I keep that from defaulting to a date?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default I type in 1-2, how can I keep that from defaulting to a date?
Hi!

You have to either preformat the cell as TEXT or precede the entry with an
apostrophe: '1-2. The apostrohe will not be visible in the cell.

Biff

"nickiann18" wrote in message
...
Whenever I put 1-2 into Excel, it defaults to 2-Jan....how can I change
it,
so it doesnt do that anymore?


Reply With QuoteReply With Quote