Once approved, I assume various font makers and Microsoft, Apple etc. I can't believe how provincial I feel. If you want to insert Rupee symbol in Excel, please refer my post on. Steps to Insert Rupee Symbol in Excel Worksheets Step1: Enter the values as desired. This made me to write rupee symbol on Dell Vostro laptop. Until that time you have to use a font like as Ninad points out above.
Step 2: Now after downloading it just Extract the file and Install the Font by clicking the Install button. He studied and graduated with Bachelors degree in Engineering Electronics and Communications from one of the Top Universities Guru Gobind Singh Indraprastha University, New Delhi in India. A Lakh Rupee is one hundred thousand rupees and a crore rupee is ten million rupees. If you delete each one and replace it with one typed in from your keyboard, my code should work then. San Most people in India want it to display like yours and can't It can be one of two things 1. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. What I think you are seeing is a left over Custom Format what my code does in a cell you changed from a constant to a formula.
When we type, we would like to use Rupee symbol rather than Rs. Clicking the Insert button should add symbol to the document. Step 3: If the Rupee Symbol is not listed in the dropdown list then click the More Symbols option. Foradian Technologies have developed this font which can be added into your Windows systems as follows. As the Indian Government announced the symbol for Indian currency lately, users mentioned the Indian currency as Indian rupees. Indian numbers are grouped differently than standard English numbers.Next
Now if you want to insert rupee symbol in the document then use the Keyboard shortcut e. S: I'm an excel noob and have picked up this code from a forum i came across. Step 4: Select Currency from the category. Quick note: I have noticed that there is even a small sweet spot for formulas placed within the R range that yield numbers between one hundred thousand a lakah and nine hundred ninty nine thousand nine hundred and ninety nine one short of a crore. There is no need to install any update or any change of keyboard layout if you want to use Rupee symbol in excel 2010. .Next
Dependents If Not Intersect Cell, R Is Nothing Then With Cell If. Click the Shortcut Key button and enter a new shortcut key e. Note — This method works perfectly on the Microsoft Versions i. Is there any permanent Solution because every-time i have to format cell. Also, your questions: 1 I dont know what the -4009 means either. மேலும் விபரங்களுக்கு கீழ் காணும் முகவரியை தொடர்பு கொள்க : சி. The Government of India has announced a new symbol for rupee.Next
The full code i am using is Sub IndianNumberFormat For Each C In Selection C. For Windows, copy the font and paste it to the designated font folder. Step 1: In the word document, navigate to the place where you want to insert Rupee symbol. After installing the font on your system just press Tilt ~ Key. NoDependents: as the last line of code immediately above the End Sub statement.Next
Hi Chandoo, I have done all the setting in system using Win8 Machine to make it Indian format but in excel it is still showing upto lacs correctly but in crores it is again not taking sample? You can easily insert rupee symbol in excel spreadsheet by choosing the currency symbol rupee in the format tab. I used a code similar to one published by someone in comments above. And a little more digging gives these additional two digit group names: arab one billion rupees , kharab one hundred billion , neel ten trillion and padma one quadrillion. Step2: Select the cells which you want to insert rupee cell. I live in Wellington, New Zealand. You can also follow me on Twitter tech2touch or my Facebook page tech2touch. Once download completes, install the update.Next
Anyway, to your question about the code working for values displayed by formulas. This may quite a old trick for you guys. I have already made a tutorial on how to windows. Dependents, R Is Nothing Then For Each Cell In Target. May be someone can tell us what is the mystery behind this. This number changes for different currency symbols. Change the number format of the cells Select some cells Ctrl 1 Custom In the Type: Box type: 0,000.Next