How to round an entire worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have found a worksheet that displays all the numbers rounded to 1000.

Exch $
(17) This number looks like (17) but if you click on the cell it is
actually -17434

I think this is some kind of "global" setting for the entire worksheet, but
I have no clue as to what it is. There is no formula of any type included in
the individual cells. Can anyone tell me what the setting is? How to remove
it?
 
Its due to number format

Select a cell and then press Ctrl+1
Now see the format it currently has...under custom Probably #,

Select number and change it to the desired format
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round up entire worksheet 9
Rounding 4
Editing an "IF" function across a worksheet/excel file 2
Rounding Existing Formulas/Values 1
Conditionally format entire worksheet 3
rounding problems 2
Rounding up to next dime 2
applying rounding formula to entire worksheet 11

Back
Top