How to Change the Currency in Microsoft Excel?

Microsoft Excel
TechLatest is supported by readers. We may earn a commission for purchases using our links. Learn more.

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.
How to Change the Currency in Microsoft Excel? 1

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


Read more:

Leave a Comment
Related Topics
Subscribe
Notify of
guest
0 Comments
Newest
Oldest
Inline Feedbacks
View all comments