[excel 2000]
on status bar, you amy select function to present, for example, sum of
selected cells
problem is that on my excel, there is written "total sum=2E+06", which is
very un-accurate
obviously, exponential form is chosen by the reason of large number of
digits in number
but, it is a sad thing that the most part of the field is occupied by the
fixed text "total sum=" [in my localized language version, this text is even
longer]
it would be much more clever to keep all diggits displayed, and in the case
of space shortage, to shorten the fixed text, wouldn't it?
so, question is:
is there some way to customize the display format on that status bar field?
thnx!
Jim Rech - 11 Oct 2007 14:06 GMT
Excel appears to use the number format you set in the Normal style. Go into
Format, Style to change it.

Signature
Jim
| [excel 2000]
|
[quoted text clipped - 16 lines]
|
| thnx!
Dave Peterson - 11 Oct 2007 14:18 GMT
Just to add to Jim's response...
First, styles live in workbooks, so you'll have to change the normal style in
every workbook that you want this behavior.
Second, I wouldn't do this if you're going to enter dates and you don't want to
change the format from that new Normal Style back to a date (same thing with
times and currency and ...).
> Excel appears to use the number format you set in the Normal style. Go into
> Format, Style to change it.
[quoted text clipped - 24 lines]
> |
> | thnx!

Signature
Dave Peterson
sali - 11 Oct 2007 15:02 GMT
thnx
it works as it has now a fixed number format
well, having to change every worksheet is not a such a bad idea, since
special number format is quite a rare occasion, and a general format is
preserved
but, is it possible to avoid *text* part of sum field display? the text
"total sum="?
having it dissappear completely, or just minimized to few letters should
leave plenty of room for number display, and number display is the real
purpose of that status bar field, isn't it?
thnx!
"Dave Peterson" <petersod@verizonXSPAM.net> je napisao u poruci interesnoj
grupi:470E22BD.BB07C423@verizonXSPAM.net...
> Just to add to Jim's response...
>
[quoted text clipped - 14 lines]
>> --
> Dave Peterson
Jim Rech - 11 Oct 2007 16:17 GMT
>>is it possible to avoid *text* part
Afraid not, sorry.

Signature
Jim
| thnx
|
[quoted text clipped - 31 lines]
| >> --
| > Dave Peterson
sali - 12 Oct 2007 08:53 GMT
ok.
just to mention [just as a wish], it would be fantastic if could be
controlable like some of the application properties [like
application.statusbar is].
the calculaton of display value could be controlled through the worksheet
selection change event
"Jim Rech" <jrrech@hotmail.com> je napisao u poruci interesnoj
grupi:OVWkPnBDIHA.1208@TK2MSFTNGP03.phx.gbl...
>>>is it possible to avoid *text* part
>
[quoted text clipped - 9 lines]
> | but, is it possible to avoid *text* part of sum field display? the text
> | "total sum="?