How to format memo for currency?

[snorkel]

Hi,
Sorry for all the questions.

Anyway, Iam porting a delphi app that used fast reports and the group footer sum field was formatted for currency
i.e.
if positive it shows $56.78 and if negative it shows (56.78)  and it also pads the values if needed for example if the
dataset value was 56.7  it would display $56.70

Thanks in advance.

Snorkel

[snorkel]

oh, forgot to add I tried to use the formatting string FR for Dephi uses:
%2.2m

but it does not work the values display like this:
%255259
for a sum of 55056.36 and 202.63

[snorkel]

This was not easy to find, so here is the solution, hope it helps someone else:

Right click on the memo object and select variable format, then select custom and paste this in:

$#,##0.00;($#,##0.00);-;-