Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Truncating to two decimals
Is there a way to trunkate to two decimals without rounding? For example:
123.45*31/12 = 318.9125 I need 318.91 234.97*42/11 = 897.15818, I need 897.15 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count digits before decimals and after decimals | Excel Worksheet Functions | |||
Truncating a VIN | Excel Discussion (Misc queries) | |||
Truncating Decimals | Excel Discussion (Misc queries) | |||
numbers truncating | Excel Discussion (Misc queries) | |||
truncating a number in VB | Excel Programming |