Currency format

[Paradigm]

I have some reports with currency columns.
Is there any way of getting the currency symbol to line up. At the moment if
the currency values have 3,4,5,etc. characters in it then the currency
symbol is immediately before the first character and this looks untidy in a
long list and I would like the symbol to line up with spaces before the
characters. Excel has a currency format that does this.
Alec

 

[Joseph Meehan]

I have some reports with currency columns.
Is there any way of getting the currency symbol to line up. At the
moment if the currency values have 3,4,5,etc. characters in it then
the currency symbol is immediately before the first character and
this looks untidy in a long list and I would like the symbol to line
up with spaces before the characters. Excel has a currency format
that does this.
Alec

Well you could add a text box right before that field with just the
currency sign and reformat the existing box/data to eliminate that sign.

 

[Paradigm]

That will work but I would have to set the width of the text box to
something to accomodate a large currency value and then if all the currency
values where only say 3 characters the symbol would be way of to the left.
Alec

 

[Joseph Meehan]

That will work but I would have to set the width of the text box to
something to accomodate a large currency value and then if all the
currency values where only say 3 characters the symbol would be way
of to the left. Alec

Well you could format it to left justified, but that would not be very
pretty either.

 

[Guest]

Re Works7
When importing into a form letter rom the database the currency layout changes
I.E £100.00 shows £100.00, £100.11 shows £100.11 but £100.10 show as £100.1
no zero at the end? this only happens with 10p, 20p ect. 09p or 12p is ok.

Any thoughts