How to add new currency symbol

[Guest]

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

 

[Bernard Liengme]

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

 

[Guest]

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

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

 

[David Biddulph]

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

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

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

 

[Guest]

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

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

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

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

 

[protexcomputers]

vinod tell me how to change it in indian currency rs

shital ([email protected])