add rupee symbol in formula

[sanjuss2]

Hi
I wan to add rupee font in front of the result of formula
in A1 Value is 3500000

& in b1
= text(a1, "[>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0")

result is showing 35,00,000.00 but I want to add rupee symbol in front of the amount

rupee font automatically get changed to D

in b1 there is another formula convert in words i.e. rswords

total formula is
= text(a1, "[>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0") & rswords(a1)

Result must be ` 35,00,000.00 Thirty Five Lakh(s) only

Pls help me to add rupee font in this formula

thanks in advance

[avk]

>Click Start -> Run -> Type charmap.exe
>Double click on the Indian Rupee Symbol and Click the Copy button
>Open excel file.
>Select the cells to format, Right Click on cells and Select Format Cells
>Click on Custom Category
>Click on the Type Textbox and Press Ctrl + V to paste Indian Rupee Symbol
>ok

[Roel Jongman]

To insert the rupee symbol in a TEXT function you will need to use Symbol functionality under the Insert menu

the Unicode(hex) code for Rupee symbol is 20B9 this will help you find the symbol easy.

I created a small example file with your formula with the rupee sign added as it is below too..

Please Login or Register  to view this content.

you should not try to use a separate font for 1 character as the cell formatting will only allow 1 font for the entire formula. as you have noticed as the rupee gets changed to D.
you have to use the available currency symbols in the character set of excel/windows instead.

in the example file I also included a screenshot of the symbol screen and marked where you need to fill 20B9 to quickly find the symbol

[sanjuss2]

On my computer I don't have rupee symbol as you have suggested in callibri font
How I can install that

[sanjuss2]

>Click Start -> Run -> Type charmap.exe
>Double click on the Indian Rupee Symbol and Click the Copy button
>Open excel file.
>Select the cells to format, Right Click on cells and Select Format Cells
>Click on Custom Category
>Click on the Type Textbox and Press Ctrl + V to paste Indian Rupee Symbol
>ok

It's not that much easy
I want symbol in formula & when I follow your steps it resulted as D

[Roel Jongman]

Hi sanjuss2,

while googling a bit more I understand the rupee symbol is rather new, I did not know that.. Microsoft has released some updates for older versions to get it added to the fonts.
https://support.microsoft.com/en-gb/...ian-rupee-in-w

so try that or google for a solution for your local needs. having the symbol in the charactermap is the best solution.
When you update you do not need to use any special tricks like I discribed. It will then be available in cel formatting for currency symbol so you can also set it as default local setting in your windows settings if you want.
rupee symbol.png

Trying to use it from a special font is difficult to combine with other text in the same cell or formula. It is only possible to have 2 different fonts in 1 cell if you type it manually.