Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

status bar sum function

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sali - 11 Oct 2007 12:50 GMT
[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="?

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.