Here is what it will look like for the Rupee Symbol: ₹#,”M” ₹#,”K” ₹#īritish Pound: £#,”M” £#,”K” £# Lets show you how to do this for the Indian Rupee Currency.Ī) To add a symbol in Excel, go to your Insert Ribbon and then on the far right, select the Symbol button in the Symbols Group.ī) Then you will see the Insert Symbol c) Edit the cell with the inserted symbol and highlight the symbol, then press CTRL+C to Copy the Rupee Symbol.ĭ) Edit your custom number format that you may have created in another cell Here is the original Thousands or Millions custom number format:ġ) If Matt’s question was to use the format without the $ (dollar sign), simply we could simply delete the dollar sign in each section and the formula will work.Ģ) Now if Matt’s wanted to use another currency symbol that already exists in Excel, then we need to 1) click on any cell in the spreadsheet 2) Insert that symbol 3) Copy and Paste the symbol into the Custom Number Format. So you will also want to edit and replace the ” quote symbols in the format before using them. NOTE: When copying any of these custom number formats below, Excel typically replaces the ” (quote) symbols with a different character that won’t work as expected. Not knowing anything else but this from Matt, I went and researched different units that one might want to use in a custom number format. “How do you use this formula without the dollar sign? I am using different units than dollars “ How-to Format Chart Axis for Thousands or Millions
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |