| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you enter a ratio e.g. 100:1 into a cell?
When I enter a ratio as above it thinks it as time. How do I do enter a
ration e.g. 100:1 in a cell? |
|
#2
|
|||
|
|||
|
How do you enter a ratio e.g. 100:1 into a cell?
Try putting an apostrophe in front
'100:1 - Search "Catcher" wrote: When I enter a ratio as above it thinks it as time. How do I do enter a ration e.g. 100:1 in a cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Why do I have to enter the cell (F2) for cell to calculate? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions | |||
Linear Mode
