cusotm formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dean - 22 Dec 2006 18:48 GMT

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

Reply to this Message

Gary Keramidas - 22 Dec 2006 18:59 GMT

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

Signature

Gary

>I have a bunch of custom formats that I use that were created by others. They
>have many symbols in them hyphens, #, etc, etc.
[quoted text clipped - 8 lines]
> Thanks!
> Dean

Reply to this Message

Gord Dibben - 22 Dec 2006 19:36 GMT

Dean

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

Gord Dibben MS Excel MVP

>I have a bunch of custom formats that I use that were created by others.
>They have many symbols in them hyphens, #, etc, etc.
[quoted text clipped - 9 lines]
>Thanks!
>Dean

Reply to this Message

Gary Keramidas - 22 Dec 2006 19:42 GMT

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

Signature

Gary

> Dean
>
[quoted text clipped - 15 lines]
>>Thanks!
>>Dean

Reply to this Message

Gord Dibben - 22 Dec 2006 19:52 GMT

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

Gord

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

Gord Dibben MS Excel MVP

Reply to this Message

Gary Keramidas - 22 Dec 2006 19:56 GMT

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.

Signature

Gary

> Just a guess, but looks OP wants a space before the digits.
>
[quoted text clipped - 4 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message

Dean - 22 Dec 2006 19:58 GMT

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

> Dean
>
[quoted text clipped - 18 lines]
>>Thanks!
>>Dean

Reply to this Message

dribler2 - 23 Dec 2006 01:41 GMT

using your custom format, assuming non-negative total

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

happy holidays hohoho
driller

> 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
[quoted text clipped - 35 lines]
> >>Thanks!
> >>Dean

Reply to this Message

Dean - 23 Dec 2006 04:20 GMT

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

> using your custom format, assuming non-negative total
>
[quoted text clipped - 56 lines]
>> >>Thanks!
>> >>Dean

Reply to this Message

dribler2 - 23 Dec 2006 14:18 GMT

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

Reply to this Message

Gord Dibben - 23 Dec 2006 17:26 GMT

Dean

Custom Formats are for numeric cells only.

Since you have a blank cell, your Total = will not show in the cell.

Gord Dibben MS Excel MVP

>Little nits: I notice that the value is right aligned. Is there a way to
>make it centered or left aligned?
[quoted text clipped - 68 lines]
>>> >>Thanks!
>>> >>Dean

Reply to this Message

Dean - 23 Dec 2006 20:48 GMT

I'm not sure what you mean. The cell has a summation formula in it. It is
not blank. Perhaps you mean that, if it evaluates to zero, then the total
won't show. Even so, it seems like Dribler2 has a solution for me.

Thanks everyone and happy holidays!
Dean

> Dean
>
[quoted text clipped - 83 lines]
>>>> >>Thanks!
>>>> >>Dean

Reply to this Message