Thread: excel queustion
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default excel queustion

Precede the entry with an apostrophe '
or format as text

--

Regards,

Peo Sjoblom


"Molly" wrote in message
...
How do I use the colon without it converting to time. For example when I
enter 1:2, it automatically converts to 1:02?