How do I stop excel from rounding numbers?
Use the truncate function. For example, if cell A1 = 1428.627, set cell B1
(or whereever you'd like the result) to =TRUNC(A1,2). This just truncates
the value to the indicated number of decimal places.
"c-swym" wrote:
I would like to be able to shut off the rounding function in excel. For
example: the number $1,428.627 I would like to have show up as $1,428.62.
Any help would be appreciated. Thank you.
|