I have a bunch of custom formats that I use that were created by others.
They have many symbols in them hyphens, #, etc, etc.

I also have learned how to have a number displayed with say "total =" in
front of it, but I only know how to do that for simple formats, such as an
integer. I tried modifying one of those custom formats with "total =" and a
spacebar in front of them, similar to how I use "total =" 0, when it is an
integer. But it did not work. So, the question is, if I want to modify an
existing custom format but just want to put some text in front of it, how do
I do that?

Thanks!
Dean

not sure what you mean, how about a specific example.

--


Gary


"Dean" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have a bunch of custom formats that I use that were created by others. They
>have many symbols in them hyphens, #, etc, etc.
>
> I also have learned how to have a number displayed with say "total =" in front
> of it, but I only know how to do that for simple formats, such as an integer.
> I tried modifying one of those custom formats with "total =" and a spacebar in
> front of them, similar to how I use "total =" 0, when it is an integer. But
> it did not work. So, the question is, if I want to modify an existing custom
> format but just want to put some text in front of it, how do I do that?
>
> Thanks!
> Dean
>

Dean

Put the space between = and " like "Total = "0


Gord Dibben MS Excel MVP

On Fri, 22 Dec 2006 10:49:23 -0800, "Dean" <(E-Mail Removed)> wrote:

>I have a bunch of custom formats that I use that were created by others.
>They have many symbols in them hyphens, #, etc, etc.
>
>I also have learned how to have a number displayed with say "total =" in
>front of it, but I only know how to do that for simple formats, such as an
>integer. I tried modifying one of those custom formats with "total =" and a
>spacebar in front of them, similar to how I use "total =" 0, when it is an
>integer. But it did not work. So, the question is, if I want to modify an
>existing custom format but just want to put some text in front of it, how do
>I do that?
>
>Thanks!
>Dean
>

i was wondering if i should post that, but wasn't sure if that's what the op
wanted.

--


Gary


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Dean
>
> Put the space between = and " like "Total = "0
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 22 Dec 2006 10:49:23 -0800, "Dean" <(E-Mail Removed)>
> wrote:
>
>>I have a bunch of custom formats that I use that were created by others.
>>They have many symbols in them hyphens, #, etc, etc.
>>
>>I also have learned how to have a number displayed with say "total =" in
>>front of it, but I only know how to do that for simple formats, such as an
>>integer. I tried modifying one of those custom formats with "total =" and a
>>spacebar in front of them, similar to how I use "total =" 0, when it is an
>>integer. But it did not work. So, the question is, if I want to modify an
>>existing custom format but just want to put some text in front of it, how do
>>I do that?
>>
>>Thanks!
>>Dean
>>
>

Just a guess, but looks OP wants a space before the digits.


Gord

On Fri, 22 Dec 2006 14:42:12 -0500, "Gary Keramidas" <GKeramidasATmsn.com>
wrote:

>i was wondering if i should post that, but wasn't sure if that's what the op
>wanted.

Gord Dibben MS Excel MVP

i had about the same response all typed up, and then figured maybe i better ask
for more info. this is way too simple for an mvp, though. someday i hope to know
half as much as you guys.

--


Gary


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Just a guess, but looks OP wants a space before the digits.
>
>
> Gord
>
> On Fri, 22 Dec 2006 14:42:12 -0500, "Gary Keramidas" <GKeramidasATmsn.com>
> wrote:
>
>>i was wondering if i should post that, but wasn't sure if that's what the op
>>wanted.
>
> Gord Dibben MS Excel MVP

Thanks, guys, I just figured it out. What I had was fine, but I was
looking at a cell whose value was zero. Apparently, if the cell's value is
zero, the "totals =" is suppressed. I'm not sure why. It's as if the
custom format knows to suppress the text that I put in front of it, which
does seem odd. Can someone explain how I could also have that text print out
even if the value is zero?

Here's the actual format I tried it with:

"Total =" _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)

Please don't waste your time explaining the details of that custom format.
I don't need to know much more than that my client likes it!

Thanks!
Dean

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> Dean
>
> Put the space between = and " like "Total = "0
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 22 Dec 2006 10:49:23 -0800, "Dean" <(E-Mail Removed)>
> wrote:
>
>>I have a bunch of custom formats that I use that were created by others.
>>They have many symbols in them hyphens, #, etc, etc.
>>
>>I also have learned how to have a number displayed with say "total =" in
>>front of it, but I only know how to do that for simple formats, such as an
>>integer. I tried modifying one of those custom formats with "total =" and
>>a
>>spacebar in front of them, similar to how I use "total =" 0, when it is an
>>integer. But it did not work. So, the question is, if I want to modify
>>an
>>existing custom format but just want to put some text in front of it, how
>>do
>>I do that?
>>
>>Thanks!
>>Dean
>>
>

using your custom format, assuming non-negative total

"Total =" _(* #,##0_)

happy holidays hohoho
driller

"Dean" wrote:

> Thanks, guys, I just figured it out. What I had was fine, but I was
> looking at a cell whose value was zero. Apparently, if the cell's value is
> zero, the "totals =" is suppressed. I'm not sure why. It's as if the
> custom format knows to suppress the text that I put in front of it, which
> does seem odd. Can someone explain how I could also have that text print out
> even if the value is zero?
>
> Here's the actual format I tried it with:
>
> "Total =" _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)
>
> Please don't waste your time explaining the details of that custom format.
> I don't need to know much more than that my client likes it!
>
> Thanks!
> Dean
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:(E-Mail Removed)...
> > Dean
> >
> > Put the space between = and " like "Total = "0
> >
> >
> > Gord Dibben MS Excel MVP
> >
> > On Fri, 22 Dec 2006 10:49:23 -0800, "Dean" <(E-Mail Removed)>
> > wrote:
> >
> >>I have a bunch of custom formats that I use that were created by others.
> >>They have many symbols in them hyphens, #, etc, etc.
> >>
> >>I also have learned how to have a number displayed with say "total =" in
> >>front of it, but I only know how to do that for simple formats, such as an
> >>integer. I tried modifying one of those custom formats with "total =" and
> >>a
> >>spacebar in front of them, similar to how I use "total =" 0, when it is an
> >>integer. But it did not work. So, the question is, if I want to modify
> >>an
> >>existing custom format but just want to put some text in front of it, how
> >>do
> >>I do that?
> >>
> >>Thanks!
> >>Dean
> >>
> >
>
>
>

Little nits: I notice that the value is right aligned. Is there a way to
make it centered or left aligned?

So, in addition to not having the problem I didn't like, what you gave me
also does the exact same thing with so many fewer characters? If so, like
WOW! If not, please tell me what feature it doesn't have. Also, can you
briefly tell me how the format can be smart enough (or dumb enough) to know
to suppress the text I put in front of it. It really seems weird.

Thanks!
Dean

"dribler2" <(E-Mail Removed)> wrote in message
news:EB7FB008-1789-4027-B6E8-(E-Mail Removed)...
> using your custom format, assuming non-negative total
>
> "Total =" _(* #,##0_)
>
> happy holidays hohoho
> driller
>
> "Dean" wrote:
>
>> Thanks, guys, I just figured it out. What I had was fine, but I was
>> looking at a cell whose value was zero. Apparently, if the cell's value
>> is
>> zero, the "totals =" is suppressed. I'm not sure why. It's as if the
>> custom format knows to suppress the text that I put in front of it, which
>> does seem odd. Can someone explain how I could also have that text print
>> out
>> even if the value is zero?
>>
>> Here's the actual format I tried it with:
>>
>> "Total =" _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)
>>
>> Please don't waste your time explaining the details of that custom
>> format.
>> I don't need to know much more than that my client likes it!
>>
>> Thanks!
>> Dean
>>
>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> news:(E-Mail Removed)...
>> > Dean
>> >
>> > Put the space between = and " like "Total = "0
>> >
>> >
>> > Gord Dibben MS Excel MVP
>> >
>> > On Fri, 22 Dec 2006 10:49:23 -0800, "Dean"
>> > <(E-Mail Removed)>
>> > wrote:
>> >
>> >>I have a bunch of custom formats that I use that were created by
>> >>others.
>> >>They have many symbols in them hyphens, #, etc, etc.
>> >>
>> >>I also have learned how to have a number displayed with say "total ="
>> >>in
>> >>front of it, but I only know how to do that for simple formats, such as
>> >>an
>> >>integer. I tried modifying one of those custom formats with "total ="
>> >>and
>> >>a
>> >>spacebar in front of them, similar to how I use "total =" 0, when it is
>> >>an
>> >>integer. But it did not work. So, the question is, if I want to
>> >>modify
>> >>an
>> >>existing custom format but just want to put some text in front of it,
>> >>how
>> >>do
>> >>I do that?
>> >>
>> >>Thanks!
>> >>Dean
>> >>
>> >
>>
>>
>>

Dean, considering to make your client be happy more further, for viewing
your previous format.

this can allow u to control for any visual alignment - using the formatting
toolbars in the menu.

"Total = " #,##0

happy holidays hohoho
dribler2