How to change currency in Excel

In this lesson, we will learn how to select and change currency in Excel and switch between different currencies.

Let us have the following information and we want to select a currency for it.

a table in Excel
a table of numbers in Excel

So we will do the following steps:

1- We select all the information.

select all the information
select all the information

2- From the toolbar and from “Home” from “Number” we will choose the option that shows the currencies.

"Number" and currency option
“Number” and currency option

3- If the currency is not in the list we choose “More Accounting Formats”.

"More Accounting Formats" to change currency
“More Accounting Formats” to change currency

4- From “Symbol” we will choose the currency we want, and assuming we choose “SAR” it will appear as follows.

"SAR" currency
“SAR” currency

Dear reader, if you liked the article, do not forget to subscribe to our YouTube channel,  which provides all new in the field of technical and completely free training courses.

You can also browse our website to access the blog and read technical topics, or learn about the training courses offered by the site.

To access the full course “Excel Course” on YouTube, click here.

Scroll to Top