| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Prevent rounding up and down
Hi
I have a table of data which has a series of percentages. The client wants these % displayed to 0 decimal places. However, Excel rounds anything 99.5% and above to 100% and 0.4% and below to 0%. Is there any way of displaying those as 99% and 1% without affecting the rest of the data or changing the decimal places? Thanks Terry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prevent user from deleting a tab prevent running macro from menu | Excel Programming | |||
| Prevent EXCEL from rounding the result of a calculation | Excel Discussion (Misc queries) | |||
| HOW CAN I PREVENT EXCEL FILES FROM BEING DELETED OR PREVENT TRASH | Excel Discussion (Misc queries) | |||
| prevent rounding up | Excel Programming | |||
| HOW TO PREVENT NUMBERS IN SPREAD SHEET FROM ROUNDING | New Users to Excel | |||
Threaded Mode
