How to Change the Currency in Microsoft Excel?

- Advertisement -

You have to change the currencies of the data if you are working on multiple currencies in your sheet. We will teach you how to change the currency in Microsoft Excel so that you can handle your data accurately. You have to format your numbers as “Currency” so that you can easily use multiple currency symbols in the same Excel spreadsheet.

Steps to Change the Currency in Microsoft Excel

  • First select all the number data you want to convert into currency.
How to Change the Currency in Microsoft Excel?
  • Then, select “Currency” from the “Number Format” drop-down list in the “Number” section of the “Home” tab.
How to Change the Currency in Microsoft Excel?
  • Then, select the the set of data you want to convert into a particular currency.
How to Change the Currency in Microsoft Excel?
  • Click on the number format window. It will open up a new window where you can see different currency options laid out.
How to Change the Currency in Microsoft Excel?
  • From the drop-down list called ‘Symbol’, select the currency you want to change the data into.
How to Change the Currency in Microsoft Excel?
  • You can apply this for any data that has been formatted to currency. You can change the currency from one to another using these simple steps.

That’s it! This is how you change the currency of data from one currency to another.


Read more:

- Advertisement -
Priya Pampati
Priya Pampatihttps://medium.com/@priyapampati18
I am a digital marketing enthusiast. I spend most of my time either or on reading many articles or on writing articles. Being from an engineering institute, techinal writing is something I enjoy doing.

Related Articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.