DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to Remove Currency Format in Excel Office 365?

When working with the Excel sheets, sometimes you want to remove the currency format. Do you have any good methods for solving this task in Excel? So here I will introduce you to some quick tricks to deal with this problem. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Steps to Remove the Currency Format:

  • First, you need to select the data range that contains the currency values.

Data range
Data range

  • Then, you need to click the Home tab from the Ribbon.

Home Tab
Home Tab

  • You can see the number formatting box in the number option.

Number formatting box
Number formatting box

  • Just click the triangle after the “Number Formatting” box, it will expand the drop-down list as shown below.

Drop down list
Dropdown list

  • Here, you can select any of the formats as you wish. For example, we will select the “Number” option.

Select Number format
Select Number format

  • Finally, it will change the currency into number format.

Result
Result

A Bottom Line:

In this way, you have learned the simple steps to remove the currency format in Excel. Hope you like this article. Mention your queries in the below comment box. To learn more, check out Geek Excel.

Related Articles:

Top comments (0)