Exporting Currency Field Without Decimal Place

Hi All,

I need to export a currency field to include the pence but without the decimal place, is this possible?

It also needs to be 11 characters wide.

I have tried a number of formats and can get the decimal point removed but I am not getting the pence displayed. :banghead:

Thanks in advance.

Exporting Currency Field Without Decimal Place