Prev: Searching Post?
Next: how do i set up format for employee attendance monthly
From: Chris T-M on 22 Apr 2010 14:48
I want numbers to show up without the 1000's, but have the real numbers
entered... I have some references to build on, but when I try to modify them
to my need, I get an undesired result.
What I want:
-$100,000 would show as $(100)
$100,000 would show as $100

What I have that works:
$#,###, truncates positive numbers as shown above.

The specific instance I need help with is this custom format (inherited &
modified based on the working ref above)
_($* #,###,);_($* (#,###,);_($* "-"??);_(@)

-100,000 shows as $(100)
100,000 shows as $100)

I would like to have $100,000 show as $100 (no end parenthesis), but still
retain the () for negative numbers.

Since I am new at this, I'd appreciate suggested formatting, plus a brief
explanation of what each piece means.

--
Thanks for your help,
Christopher
From: Luke M on 22 Apr 2010 15:21
Try this:
$#,###,;$(#,###,);$"-";@

Explaination:
Custom format works by defining format for:
postive;negative;zero;text

Formatting says you want specific symbolts in front (the dollar sign) and
you want parenthesis around the number for negative numbers. You want to
drop the last 3 digits (hence the comma at end of number) but you also want
to use a thousands seperator (hence the comma in middle of hash marks). A
zero is displayed as a simple dash, and if it's text, I don't care, just
display text (indicated by the @ symbol).

--
Best Regards,

Luke M
"Chris T-M" <ChrisTM(a)discussions.microsoft.com> wrote in message
news:9EB789EB-5927-43C7-AB51-A8669A587ED7(a)microsoft.com...
>I want numbers to show up without the 1000's, but have the real numbers
> entered... I have some references to build on, but when I try to modify
> them
> to my need, I get an undesired result.
> What I want:
> -$100,000 would show as $(100)
> $100,000 would show as $100
>
> What I have that works:
> $#,###, truncates positive numbers as shown above.
>
> The specific instance I need help with is this custom format (inherited &
> modified based on the working ref above)
> _($* #,###,);_($* (#,###,);_($* "-"??);_(@)
>
> -100,000 shows as $(100)
> 100,000 shows as $100)
>
> I would like to have $100,000 show as $100 (no end parenthesis), but still
> retain the () for negative numbers.
>
> Since I am new at this, I'd appreciate suggested formatting, plus a brief
> explanation of what each piece means.
>
> --
> Thanks for your help,
> Christopher


From: Chris T-M on 22 Apr 2010 16:04
That worked perfect, and thank you so much for the explanation!
--
Christopher


"Luke M" wrote:

> Try this:
> $#,###,;$(#,###,);$"-";@
>
> Explaination:
> Custom format works by defining format for:
> postive;negative;zero;text
>
> Formatting says you want specific symbolts in front (the dollar sign) and
> you want parenthesis around the number for negative numbers. You want to
> drop the last 3 digits (hence the comma at end of number) but you also want
> to use a thousands seperator (hence the comma in middle of hash marks). A
> zero is displayed as a simple dash, and if it's text, I don't care, just
> display text (indicated by the @ symbol).
>
> --
> Best Regards,
>
> Luke M
> "Chris T-M" <ChrisTM(a)discussions.microsoft.com> wrote in message
> news:9EB789EB-5927-43C7-AB51-A8669A587ED7(a)microsoft.com...
> >I want numbers to show up without the 1000's, but have the real numbers
> > entered... I have some references to build on, but when I try to modify
> > them
> > to my need, I get an undesired result.
> > What I want:
> > -$100,000 would show as $(100)
> > $100,000 would show as $100
> >
> > What I have that works:
> > $#,###, truncates positive numbers as shown above.
> >
> > The specific instance I need help with is this custom format (inherited &
> > modified based on the working ref above)
> > _($* #,###,);_($* (#,###,);_($* "-"??);_(@)
> >
> > -100,000 shows as $(100)
> > 100,000 shows as $100)
> >
> > I would like to have $100,000 show as $100 (no end parenthesis), but still
> > retain the () for negative numbers.
> >
> > Since I am new at this, I'd appreciate suggested formatting, plus a brief
> > explanation of what each piece means.
> >
> > --
> > Thanks for your help,
> > Christopher
>
>
> .
>
 | 
Pages: 1
Prev: Searching Post?
Next: how do i set up format for employee attendance monthly