I have a budget spreadsheet and need to change the numbers. Currently,
some values could be 1833.3345. I know how to change the display so
that it shows as 1833.33. My question is, how do I actually change the
original number to become 1833.33 - not just be displayed as that?

Jenn

=ROUND(A1,2)
--
Gary''s Student


" wrote:

I have a budget spreadsheet and need to change the numbers. Currently,
some values could be 1833.3345. I know how to change the display so
that it shows as 1833.33. My question is, how do I actually change the
original number to become 1833.33 - not just be displayed as that?

Jenn

First, format to 2 decimal places to display 1833.33 as you have stated.

Second, go to ToolsOptionsCalculation and check "precision as displayed"

Note: this will permanently change the number to 1833.33


Gord Dibben MS Excel MVP

On 3 Mar 2006 13:05:30 -0800, wrote:

I have a budget spreadsheet and need to change the numbers. Currently,
some values could be 1833.3345. I know how to change the display so
that it shows as 1833.33. My question is, how do I actually change the
original number to become 1833.33 - not just be displayed as that?

Jenn

wrote in message
oups.com...
I have a budget spreadsheet and need to change the numbers. Currently,
some values could be 1833.3345. I know how to change the display so
that it shows as 1833.33. My question is, how do I actually change the
original number to become 1833.33 - not just be displayed as that?

Jenn



I assume there's a formula in that cell, deriving the number from other
cells, right? Use the ROUND() function, making it part of your original
formula.

THANKS!!! That worked perfectly!!! You've saved me much time and
effort!!

Jenn