Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number in cell increase with increase in font size.
I have a number in a cell say 10.5 in 12 point font size. If I increas the
font size to say 14 point the number in the cell also increases. Why? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number in cell increase with increase in font size.
Could it be that the value isn't really changing, but the column is no longer
wide enough to display the decimal places? If the number is formatted as general, excel will display as much as it can--but round the number and display that. Try widening the column to see if that helps. Value increases with increase in font. wrote: I have a number in a cell say 10.5 in 12 point font size. If I increas the font size to say 14 point the number in the cell also increases. Why? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number in cell increase with increase in font size.
Aint you clever!!
Thanks a lot. I thought there was a problem with rthe prgramme. Once again thanks for tha advice. Peter "Dave Peterson" wrote: Could it be that the value isn't really changing, but the column is no longer wide enough to display the decimal places? If the number is formatted as general, excel will display as much as it can--but round the number and display that. Try widening the column to see if that helps. Value increases with increase in font. wrote: I have a number in a cell say 10.5 in 12 point font size. If I increas the font size to say 14 point the number in the cell also increases. Why? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I increase the font size in a cell validation list? | Excel Discussion (Misc queries) | |||
increase font size in status bar: excel sums | Excel Discussion (Misc queries) | |||
How to increase font size in drop downs within workbook | Excel Worksheet Functions | |||
How to increase font size in drop-down controll | Excel Discussion (Misc queries) | |||
how to increase the font size in a dropdown list? | Excel Worksheet Functions |