How do I stop excel from changing my ratios into time format?

Q

Qlmmb2000

I'm trying to type ratios such as "0:1:0" into my excel spredsheet. Excel,
in its infinite wisdom, keeps changing it to "12:01:00 AM." How do I tell
excel to leave the cell alone after I type what I WANT to go into it?
 
F

Franz Verga

Qlmmb2000 said:
I'm trying to type ratios such as "0:1:0" into my excel spredsheet.
Excel, in its infinite wisdom, keeps changing it to "12:01:00 AM."
How do I tell excel to leave the cell alone after I type what I WANT
to go into it?
Click to expand...

You should format the cell before typing


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
G

Gary''s Student

Either precede you data with an apostrophe (single quote) as it is typed in
or format the cell as Text before entering the data.
 
Top