Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default 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.

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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.



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change Font size based upon cell input Ashley McKay Excel Discussion (Misc queries) 5 March 23rd 07 06:44 PM
change scaling % but font size didnt change porportionally, pls he Scaling question Excel Discussion (Misc queries) 0 March 12th 07 03:16 AM
Change all text one font size up with various font sizes used. omchrystal New Users to Excel 2 March 6th 07 09:01 PM
how to change font size on calender Bert New Users to Excel 2 December 20th 05 06:02 PM
Change Font Size Steve Klenner Excel Worksheet Functions 2 November 14th 04 09:34 PM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"