View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Vinod[_2_] Vinod[_2_] is offline
external usenet poster
 
Posts: 72
Default How to add new currency symbol

Thanks alot Mr. Bernard and Mr. David, its working fine.

"David Biddulph" wrote:

Format/ Cells/ Custom, then copy the relevant formatting string from
Bernard's message below into the formatting dialogue box.
--
David Biddulph

"Vinod" wrote in message
...
Thanks for the response,

I couldn't find any format like this [$Rs] #,##0.00 or #,##0.00 [$Rs] at
Format|Cells|Custom.

If it is possible please give me the solution in step by step to add
currency symobl
[$Rs] #,##0.00 or #,##0.00 [$Rs] at Format|Cells|Custom.

Regards,
Vinod

"Bernard Liengme" wrote:

Custom format [$Rs] #,##0.00 or #,##0.00 [$Rs] depend where symbol should
be
(before/after value)
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
Microsoft Excel MVP
remove CAPS in email address


"Vinod" wrote in message
...
Is there any possibility to add new formats at "Number" tab in format
cells
dialog box apart from bult-in formats .

I wanted to add Indian currency (Rs) symbol in currency format list.

Advanced Thanks,
Vinod