Thread: Currency Symbol
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Currency Symbol

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