View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Doug Kanter
 
Posts: n/a
Default Changing Numbers in Excel

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.