How do I get MS Excel to display 100000 as 1 00000?

How do I get MS Excel to display 100000 as 1 00000?

  1. Step1: Goto Control Panel and click on Region (highlighted with blue cirle)
  2. Step2: Click on “Additional Settings” in Region.
  3. Step3: Change the Digit format the one which you are looking.
  4. Step4: Do the same Digit grouping selection in Currency also and click on “Apply” and “Ok”.

Who designed the ₹ Indian RS symbol?

Udaya Kumar
The Indian rupee sign (₹) is the currency symbol for the Indian rupee, the official currency of India. Designed by Udaya Kumar, it was presented to the public by the Government of India on 15 July 2010, following its selection through an open competition among Indian residents.

How do I put the RS symbol on my computer?

On the keyboard Type 20B9. Then press Alt + x. As soon as you press 20B9 will be replaced by the ₹ symbol.

How to show Indian currency format in Excel?

A permanent solution to Indian Number Formats: 1 Goto the Control panel and select the “Region and Language” button 2 Select “Additional Settings” 3 Set digit groupings to the Indian grouping like this: 4 Do the same on the Currency Tab and Apply

Which is the second font for Indian rupee?

The second font was developed by Indian Type Foundry (ITF). The ITF Rupee font has 20 variations of the symbol. Each variation can be typed by pressing keys from A to T. If you press A, the first variation of rupee symbol appears; if you B, second variation will come; so on and so forth.

How to type rupee symbol in ITF font?

The ITF Rupee font has 20 variations of the symbol. Each variation can be typed by pressing keys from A to T. If you press A, the first variation of rupee symbol appears; if you B, second variation will come; so on and so forth. Double click on the file to open it Click on the Install button to do the installation

Where do I find the currency symbol in Excel?

On the “Number” tab, “Currency” should be selected in the “Category” list. Click on the “Symbol” drop-down list, scroll down to the “Euro” options and select one, depending on whether you want the Euro symbol before or after the number. Click “OK”.