| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to display ratio
Use
'1:3 -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Eskimo" wrote in message ... I want to display 1:3 (in a cell) exactly as is and it keeps changing it to 1:03. I have tried all the formatting and can't seem to figure out how to do it. Any other suggestions or did I miss something? Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
| How can I display a number as a ratio of x:1 in Excel? | Excel Worksheet Functions | |||
| How do I calculate and display ratio ( format 3.5:2) | Excel Worksheet Functions | |||
| How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Hybrid Mode
