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

[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?

[Franz Verga]

Qlmmb2000 wrote:
> 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?

You should format the cell before typing


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

[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.
--
Gary's Student


"Qlmmb2000" wrote:

> 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?

[Marcelo]

Hi, format the range as text

HTH
regards from Brazil
Marcelo

"Qlmmb2000" escreveu:

> 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?