Changing Numbers in Excel

[jvanicky@gmail.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

[Gary''s Student]

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


"jvanicky@gmail.com" 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
>
>

[Doug Kanter]

<jvanicky@gmail.com> wrote in message
news:1141419930.457210.171040@i39g2000cwa.googlegroups.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.

[Gord Dibben]

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

Second, go to Tools>Options>Calculation 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, jvanicky@gmail.com 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

[jvanicky@gmail.com]

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

Jenn