Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I want to format a number cell without the decimal and without ro.
I need to format the number cell so that it will still show the numbers after
the decimal, but not show the decimal point at all. It must also display leading zeros, which is not a problem. I just need a way to strip the decimal from the number. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
Format a cell to display decimal hours. | Excel Discussion (Misc queries) | |||
Format decimal controls do not work | Excel Discussion (Misc queries) | |||
number format keeps dividing by 100 | New Users to Excel | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |