Thread: I type in 1-2, how can I keep that from defaulting to a date?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default I type in 1-2, how can I keep that from defaulting to a date?
One way is to type a preceding apostrophe: '
before entering "1-2"

Another way is to preformat the column / row as text
(via Format Cells Text OK)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"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