Converting a number to currency including formatting

[lissa1974]

Hi there, we have a field in a database (SQL, running crystal 8.5 taking data from oracle Enterpriseone app)with numbers inserted into it. These represent the value of contracts. For instance...

Row1 = 347660
Row2 = 98373322
Row3 = 48473

What they look like in the system and what they represent is this..

Row1 = £3,476.60
Row2 = £983,733.22
Row3 = £484.73

So my question is how can I have them display and add up like section 2?

I take it I need to format the number in some way to say the last two digits are pence??

Any help would be welcome.

Thanks

 

[lbass]

You need to use a formula to divide the number by 100. Then format the formula to display the currency symbol.

-LB