| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why is Excel rounding when I truncate?
I have a formula:
=L2*M2*0.00125 this gives me the number 252.96 if i truncate to zero decimal places using cell formatting it returns 253??? Also if the value is 252.46 it truncates to 252? How is it doing this? I though truncating meant removing the extra decimals not rounding. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I truncate a text field in Excel? | Excel Worksheet Functions | |||
| How to truncate to tenths digits without rounding | Excel Worksheet Functions | |||
| How do I truncate something like this? | Excel Discussion (Misc queries) | |||
| linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
| I want to truncate/crop 3854502.2 into 545 in Excel. How do I do. | Excel Worksheet Functions | |||
Threaded Mode
