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