Custom Formatting (# x 1000)
 

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

Custom Formatting (# x 1000)
 

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

Custom Formatting (# x 1000)
 

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


.