When I change the font size in a cell the value changes.
 

I have a value in a cell in 10 point, the rest of the worksheet is in 12. If
I increase the font size, the value in the cell also increases. This problem
is only in one cell. I have gone through the clear cell procedure to no
avail. Any ideas why this should happen. I have also run detect and repair.
Peter.

When I change the font size in a cell the value changes.
 

is it a formula in the cell?
if so what is it
what happens when there is text?

"Value increases with increase in font." wrote:

I have a value in a cell in 10 point, the rest of the worksheet is in 12. If
I increase the font size, the value in the cell also increases. This problem
is only in one cell. I have gone through the clear cell procedure to no
avail. Any ideas why this should happen. I have also run detect and repair.
Peter.

When I change the font size in a cell the value changes.
 

"Value increases with increase in font." wrote:

I have a value in a cell in 10 point, the rest of the worksheet is in 12. If
I increase the font size, the value in the cell also increases. This problem
is only in one cell. I have gone through the clear cell procedure to no
avail. Any ideas why this should happen. I have also run detect and repair.
Peter.

No there is no formula.
Peter

When I change the font size in a cell the value changes.
 

No there is no formula.
peter

"Value increases with increase in font." wrote:

I have a value in a cell in 10 point, the rest of the worksheet is in 12. If
I increase the font size, the value in the cell also increases. This problem
is only in one cell. I have gone through the clear cell procedure to no
avail. Any ideas why this should happen. I have also run detect and repair.
Peter.

When I change the font size in a cell the value changes.
 

what is the value before change and after change?
what haopens if you open in safe mode?


"Value increases with increase in font." wrote:

No there is no formula.
peter

"Value increases with increase in font." wrote:

I have a value in a cell in 10 point, the rest of the worksheet is in 12. If
I increase the font size, the value in the cell also increases. This problem
is only in one cell. I have gone through the clear cell procedure to no
avail. Any ideas why this should happen. I have also run detect and repair.
Peter.

When I change the font size in a cell the value changes.
 

Hi bj

What I have done is to cut and paste the workbook onto a new excel woorkbook
under a new name and it has solved the problem.
Thanks for your help anyway.
W K R
Peter

"bj" wrote:

what is the value before change and after change?
what haopens if you open in safe mode?


"Value increases with increase in font." wrote:

No there is no formula.
peter

"Value increases with increase in font." wrote:

I have a value in a cell in 10 point, the rest of the worksheet is in 12. If
I increase the font size, the value in the cell also increases. This problem
is only in one cell. I have gone through the clear cell procedure to no
avail. Any ideas why this should happen. I have also run detect and repair.
Peter.