Home |
Search |
Today's Posts |
#1
|
|||
|
|||
truncate
How do I truncate my numbers so that $54.2223456 is changed to $54.22? I
know how to round, but I want the actual base number to be truncated, not simply the number that appears in the cell. All my numbers are currency, so want two numbers after the decimal. I tried truncating to a certain number of total characters, but that doesn't help since $54.22 has fewer characters than $13294.32, but both are correct. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
truncate ssn to first four digits | Excel Discussion (Misc queries) | |||
I WANT to truncate my leading zeros | Excel Discussion (Misc queries) | |||
Truncate scientific notation | Excel Worksheet Functions | |||
fill or truncate to a certain number of characters in a cell | Excel Worksheet Functions | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) |