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" wrote in message
...
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" 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
...
Dean

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


Gord Dibben MS Excel MVP

On Fri, 22 Dec 2006 10:49:23 -0800, "Dean"
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
...
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
...
Dean

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


Gord Dibben MS Excel MVP

On Fri, 22 Dec 2006 10:49:23 -0800, "Dean"
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