Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosum displays a hashed box. Any suggestions?
Hi there,
I'm trying to use the autosum feature on an excel spreadhsheet but the answer box only displays a series of hashes, i.e. ### However, when I move the cursor over the box, the correct value is displayed beneath it. What do I need to do for the actual number to be displayed in the box?? Many thanks, KB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosum displays a hashed box. Any suggestions?
Is the column wide enough to display the value?
"KB" wrote in message ... Hi there, I'm trying to use the autosum feature on an excel spreadhsheet but the answer box only displays a series of hashes, i.e. ### However, when I move the cursor over the box, the correct value is displayed beneath it. What do I need to do for the actual number to be displayed in the box?? Many thanks, KB |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosum displays a hashed box. Any suggestions?
OK. Now I feel like an idiot ;-)
Thanks, problem resolved. KB "KB" wrote: Hi there, I'm trying to use the autosum feature on an excel spreadhsheet but the answer box only displays a series of hashes, i.e. ### However, when I move the cursor over the box, the correct value is displayed beneath it. What do I need to do for the actual number to be displayed in the box?? Many thanks, KB |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autosum displays a hashed box. Any suggestions?
Now I feel like an idiot ;-)
Thanks, problem resolved. KB "KB" wrote: Hi there, I'm trying to use the autosum feature on an excel spreadhsheet but the answer box only displays a series of hashes, i.e. ### However, when I move the cursor over the box, the correct value is displayed beneath it. What do I need to do for the actual number to be displayed in the box?? Many thanks, KB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autosum | Excel Discussion (Misc queries) | |||
Need formula that reads value and then displays value from same row, different column | Excel Worksheet Functions | |||
autosum ?? | Excel Worksheet Functions | |||
autosum problems | Excel Worksheet Functions | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |