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.

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.

"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

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.

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.

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.