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.
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.
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
Google is your best friend!
You could use the ROUNDDOWN function in another cell
=ROUNDDOWN(A1,2)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS
"c-swym" <[email protected]> wrote in message
news:[email protected]...
>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.
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)
"c-swym" <[email protected]> wrote in message
news:[email protected]...
> 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.
"c-swym" <[email protected]> wrote in message
news:[email protected]...
>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
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks