How do I stop excel from rounding numbers?
 

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.

How do I stop excel from rounding numbers?
 

You could use the ROUNDDOWN function in another cell

=ROUNDDOWN(A1,2)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"c-swym" wrote in message
...
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.

How do I stop excel from rounding numbers?
 

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=551636

How do I stop excel from rounding numbers?
 

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, FormatCellsCurrency. 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)

"c-swym" wrote in message
...
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.

How do I stop excel from rounding numbers?
 

"c-swym" wrote in message
...
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)
--
David Biddulph

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.

How do I stop excel from rounding numbers?
 

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

"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.