Changing Numbers in Excel

J

jvanicky

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
 
G

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
 
D

Doug Kanter

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
Click to expand...


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

jvanicky

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

Jenn
 
Top