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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Either precede you data with an apostrophe (single quote) as it is typed in
or format the cell as Text before entering the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Screen vs. Printed Aspect Ratio 1
Help with normal distribution, generating ratios for bell-shape cu 5
How to STOP Excel from changing my data 1
How do I maintain format in programs. 1
How do I express a ratio? 2
I don't want excell to change ratios to fractions, what to do? 1
i want to convert decimals into time format 3
How do I stop Excel from auto-inserting a date? 1

Back
Top