How to add new currency symbol

V

Vinod

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
 
B

Bernard Liengme

Custom format [$Rs] #,##0.00 or #,##0.00 [$Rs] depend where symbol should be
(before/after value)
best wishes
 
V

Vinod

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 said:
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 said:
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
 
D

David Biddulph

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

Vinod said:
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 said:
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 said:
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
 
V

Vinod

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

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

Vinod said:
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 said:
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


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top