Number Formatting
Posted by Leslie on January 17, 2002 1:56 PM
I want to set up a custom format to both truncate the last three digits AND if the number is negative, have the number in parenthesis, not with a negative sign in front. I can do one or the other, but not both. Seems silly, but for some strange reason, I can't figure this out. Thanks.
Posted by Qroozn on January 17, 2002 2:39 PM
can you tell me what the customer format is for each curently?
Posted by Mark W. on January 17, 2002 2:44 PM
The only format that I can think of is...
0,;(0,)
...but, this rounds rather than truncates. I'm
curious... What's the number format that you
believe truncates. To the best of my knowledge
there isn't one. By truncating the last 3 digits
do you mean converting to 1,000's?
Posted by Leslie on January 17, 2002 3:38 PM
Re: The only format that I can think of is...
I did mean converting to $1,000's. I did manage to figure out how to do this, put parenthesis around the negative numbers, and make zero show up as a 0. The only thing I can't do now is center the number. The formula I'm using now pushes all data to the right. The formula I'm using is: _(* #,##0,; _(* (#,##0,)
Do you know how to make it so I can center the number? Pushing the center button on the keyboard does not work.
Posted by Sam S on January 17, 2002 6:35 PM
try this #,##0,;(#,##0,);-
this will make zero's show as "-" but will show values less than $1,000 as "0" which is a another way to go.
don't have an answer for the centering though
Posted by Mark W. on January 21, 2002 6:51 AM
Format as #,##0,;(#,##0,) and apply a Center horizontal alignment (nt)
Posted by Mark W. on January 21, 2002 6:53 AM
Format as #,##0,;(#,##0,) and apply a Center horizontal alignment (nt)
