How to add new currency symbol
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 |
Answer: How to add new currency symbol
Hi Vinod,
Yes, you can definitely add a new currency symbol to the "Number" tab in the format cells dialog box in Excel. Here's how you can do it:
Now, you should be able to see the new currency symbol (Rs) in the "Symbol" list under the "Currency" category in the "Number" tab of the format cells dialog box. |
How to add new currency symbol
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 |
How to add new currency symbol
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 |
How to add new currency symbol
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 |
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 |
How to add new currency symbol
vinod tell me how to change it in indian currency rs
****al ) "Vinod" wrote: 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 |
All times are GMT +1. The time now is 04:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com