Formatting to Currency ?

[EnergyTed]

I have a csv file, two fields within this are populated with currency figures.

The problem being they are displayed like so - 12 958.06.

I would like to find a way to format these fields to show £12958.06 or £12,958.06.

Any help or advice would be greatly appreciated.


Kind Regards

Ted

 

[PHV]

You may consider the Format function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886