Try the below...

Right clickFormatCellsCustomType:=

[$AFG] #,##0.00

In the above example AFG is the currency sympol


--
Jacob (MVP - Excel)


"Jefferson Yesupatham" wrote:

how to manually enter a currency symbol when it is not available in Excel. It
says that the ANSI code for the symbol could be used. If so how and where the
code needs to be entered