| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Currency Symbol
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Currency Symbol
Hi Jefferson
Go to Insert Symbol Select the symbol you like and at the bottom right, select ASCII (Decimal). Just beside it, you should see Character Code EX: for the Euro Sigh, its 128. You Press and hold the Alt key and on the numeric key pad press 0128. you need to add a 0 before the code. Don't use the numbers above the letters. HTH John "Jefferson Yesupatham" <Jefferson wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add new currency symbol | Excel Discussion (Misc queries) | |||
| How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
| Yen currency symbol | Excel Discussion (Misc queries) | |||
| How do I add a currency symbol | Excel Discussion (Misc queries) | |||
| Currency Symbol | Setting up and Configuration of Excel | |||
Linear Mode
