Right justifing numbers when printing

[Tomexx]

Hi,
I have a flex grid filled with rows of numbers (prices) that when printed need to be right justified like in the real world. Eg. cents under cents:

Wrong way: the way it's printing them
$1543.92
$24.75

Right way: the way I'd like it to be printed
$1543.92
xx$24.75 (off course without the x's)

I tried to use the Format() but no luck. Can anyone help?
Thanks.

[Tomexx]

I'm beginning to think that there is no way (no easy way) which is very strange to say the least. I can't imagine why wouldn't MS include a function for right-justifing currency when printing.

Anyone?

[d.paulson]

to right justify

text1 = Format(text1,"@@@@@@@")