| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop excel from changing my ratios into time format?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop excel from changing my ratios into time format?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop excel from changing my ratios into time format?
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I stop excel from changing my ratios into time format?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can excel be a time clock or stop watch? | New Users to Excel | |||
| Excel Cell Format for Time | Excel Discussion (Misc queries) | |||
| How to get Excel to stop formatting time cells incorrectly | Excel Discussion (Misc queries) | |||
| How do I stop excel automatically opening in e-mail format? | Excel Discussion (Misc queries) | |||
| Stop Excel from changing numbers to dates in CSV file | Excel Discussion (Misc queries) | |||
Hybrid Mode
