How do I stop excel from rounding numbers?

[Guest]

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.

 

[Nick Hodge]

You could use the ROUNDDOWN function in another cell

=ROUNDDOWN(A1,2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Bearacade]

Right click on the cell(s) you need to change, select format cells, i
the Number Tab, select Currency, and select 3 in the decimal plac

 

[Bob Phillips]

Is it rounding or not, your description is confusing?

If you seen $1,428.627, it is not rounding. If you want to see it to 2 dec
pl., just set it to currency format, Format>Cells>Currency. This will stil
have the .007 in the number and will add that into any subsequent sums etc.
You can avoid this by rounding within the sum, such as

=SUM(ROUND(A1:A2,2))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[David Biddulph]

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.

If you merely want to display with 2 decimal places but retain the full
precision, the Format/ Cells/ Number, and select 2 decimal places.
If you actually want to change the value, then use the formula =ROUND(A1,2)

 

[Guest]

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.

 

[Guest]

The response from Paul Mathews was the answer I was looking for and worked
perfectly. Thank you!