thank you , but it works on the Spreedsheet only not on the invoice, i want
to type Rands on the invoice your instructions works on main excel. please
check your invoice and see if you can change doller to R

"aristotle" wrote:

Sylivia,

Choose a defined currency format that you like, and then click on custom (at
the bottom of the list). You'll see the format in its code, simply replace
each currency symbol within that line with R.

Cheers,
A

"sylvia" wrote:

i want to currency on to rands on excel invoice and my format cell is not
activeted