Help plse!

[Guest]

Here's the situation...
I have a forecast spreadsheet that I am doing and I enter in the data for each month. I have saved it. It is not linked to another worksheet so nothing should affect what I saved. However, when I go back in, the data have changed in some areas. I print it off... then close it and go back into it. Some of the values have changed again so it doesn't look exactly like the original data I typed in and also the sheet I printed out the second time I went in. Does anyone know what's going on? Why are some numbers changing when I close the file and then go back in without me doing any changes?
Any help/advice would be appreciated!

 

[William]

Have you turned off automatic calculation before you close the file. If so,
put it back on.

--
XL2002
Regards

William

(e-mail address removed)

| Here's the situation...
| I have a forecast spreadsheet that I am doing and I enter in the data for
each month. I have saved it. It is not linked to another worksheet so
nothing should affect what I saved. However, when I go back in, the data
have changed in some areas. I print it off... then close it and go back
into it. Some of the values have changed again so it doesn't look exactly
like the original data I typed in and also the sheet I printed out the
second time I went in. Does anyone know what's going on? Why are some
numbers changing when I close the file and then go back in without me doing
any changes?
| Any help/advice would be appreciated!

 

[Guest]

Is the data really changing, or just displaying differently because of formatting. (E.g. 2.09999 would display as 2.1 if the format was set to display only one decimal place).

Just a thought.