Is there a bracket (financial) format?

  • Thread starter Thread starter 8020
  • Start date Start date
8

8020

On a report can a negative number be bracketed, rather than show the -ve sign?
e.g.

-123.45
(123.45)

Seems simple but, I just can't find the format. All help much appreciated.
 
hi,
On a report can a negative number be bracketed, rather than show the -ve sign?
e.g.
-123.45
(123.45)
Click to expand...
Try this as format string:

0,00;(0,00)

You may add a third value for empty (NULL) values, e.g

0,00;(0,00);"n/a"


mfG
--> stefan <--
 
Thanks Stefan, much appreciated.

Any idea how I could line up the numbers (decimal points), so that the
brackets fall outside the number on the right.
 
hi,
Any idea how I could line up the numbers (decimal points), so that the
brackets fall outside the number on the right.
Click to expand...
Sorry, I'm not sure what you mean.



mfG
--> stefan <--
 
Stefan Hoffmann said:
hi,

Sorry, I'm not sure what you mean.



mfG
--> stefan <--
Click to expand...


He wants all the decimal places to line up. With the brackets for negatives,
the decimal place is shifted slightly to the left.

John... Visio MVP
 
hi Chuck,
Add a space after the positive values to push the decimal point to the left as:
0,00 & " ";(0,00)
Click to expand...
Ah, I see.

You need a monospaced font for that type of solution.



mfG
--> stefan <--
 
Thanks for that guys, much appreciated. I'm using a smallish font (Arial 7)
so I may get away with the "space" solution. If not, I'll give the split
field a go (very inventive!).
 
Chuck,
I played around for quite a while trying to make this work (A03). I then
created a new (simple) report and just as you say it was fine (decimal points
lined up). I've since recreated the report from scratch and got just what I
wanted. Not sure what I was doing wrong but, now all is good. Thanks again
for your input.
 
Back
Top