Is there a bracket (financial) format?

[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.

 

[Stefan Hoffmann]

hi,

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

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 <--

 

[8020]

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.

 

[Stefan Hoffmann]

hi,

Any idea how I could line up the numbers (decimal points), so that the
brackets fall outside the number on the right.

Sorry, I'm not sure what you mean.



mfG
--> stefan <--

 

[John... Visio MVP]

hi,

Sorry, I'm not sure what you mean.



mfG
--> stefan <--

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

 

[Chuck]

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

Add a space after the positive values to push the decimal point to the left as:
0,00 & " ";(0,00)

Chuck

 

[Stefan Hoffmann]

hi Chuck,

Add a space after the positive values to push the decimal point to the left as:
0,00 & " ";(0,00)

Ah, I see.

You need a monospaced font for that type of solution.



mfG
--> stefan <--

 

[Chuck]

hi Chuck,

Ah, I see.

You need a monospaced font for that type of solution.



mfG
--> stefan <--

You are correct. However the ) is a fairly thin character as is a space
character. They are not the same, but in a report in a A97 mdb that I ginned
up and using a font of Arial 8 Normal, the difference is less than a pencil
line width when drawing a line top to bottom on the printed output. Of course
your milage may vary.

Chuck

 

[Stefan Hoffmann]

hi Chuck,

Of course your milage may vary.

<g> yeah, it does


mfG
--> stefan <--

 

[Chuck]

hi Chuck,

<g> yeah, it does


mfG
--> stefan <--

Assuming you are using this in a report, another approach is to split the field
into two parts, the whole part and the decimal pard. Then display them in two
text boxes end to end.

Chuck

 

[8020]

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]

Since you said that the data with brackets did not line up the decimal points,
I didn't bother to check it. So today I did. In an A97 report, using Right
Justification for the Text Box with the currency data, the decimal points for
$123.45 and ($123.45) did line up. The field without the brackets was
automatically shifted notably left. The same thing happened when exporting to
an Excel 97 file.

Chuck

 

[8020]

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.