excel queustion
 

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

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?

excel queustion
 

I think you may need to set the number format for those cells to text.

FormatCellsNumber tab
Category: Text

Alternatively, the Fraction number format may work for you.

Does that help?

***********
Regards,
Ron


"Molly" wrote:

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