close

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

Is the column wide enough to display the value?

quot;KBquot; gt; wrote in message
...
gt; Hi there,
gt;
gt; I'm trying to use the autosum feature on an excel spreadhsheet but the
gt; answer box only displays a series of hashes, i.e. ###
gt;
gt; However, when I move the cursor over the box, the correct value is
gt; displayed
gt; beneath it.
gt;
gt; What do I need to do for the actual number to be displayed in the box??
gt;
gt; Many thanks,
gt; KB
OK. Now I feel like an idiot ;-)

Thanks, problem resolved.

KB

quot;KBquot; wrote:

gt; Hi there,
gt;
gt; I'm trying to use the autosum feature on an excel spreadhsheet but the
gt; answer box only displays a series of hashes, i.e. ###
gt;
gt; However, when I move the cursor over the box, the correct value is displayed
gt; beneath it.
gt;
gt; What do I need to do for the actual number to be displayed in the box??
gt;
gt; Many thanks,
gt; KB

Now I feel like an idiot ;-)

Thanks, problem resolved.

KB

quot;KBquot; wrote:

gt; Hi there,
gt;
gt; I'm trying to use the autosum feature on an excel spreadhsheet but the
gt; answer box only displays a series of hashes, i.e. ###
gt;
gt; However, when I move the cursor over the box, the correct value is displayed
gt; beneath it.
gt;
gt; What do I need to do for the actual number to be displayed in the box??
gt;
gt; Many thanks,
gt; KB

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()