How to round an entire worksheet?
 

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?

How to round an entire worksheet?
 

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


"Carolyn" wrote in message
...
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?