Excel VBA

Hi Jon

Thank you for your question

Using the currency data type allows the correct representation of a particualar currency, especially in terms of the currency symbol as well as its position before or after the numeric part of the figure. It also allows the correct representation of negative number using the standard accounting conventions.

Decimal places need to be formatted separately as diffenent currencies work to different decimal levels

Regards

Stephen