software

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 Studentquot; wrote:

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

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

Second, go to Toolsgt;Optionsgt;Calculation and check quot;precision as displayedquot;

Note: this will permanently change the number to 1833.33Gord Dibben MS Excel MVP

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

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