• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

How to Convert Arabic Numbers to English in Excel

October 16, 2021 by Andrew Childress
Convert Arabic numbers to English in Excel

When you work in Excel, you may find yourself using many types of numbers. Let’s learn how to convert Arabic numbers to English in Microsoft Excel. 

When you work in Excel, you may find yourself using many types of numbers. On occasion, you may be working with Arabic numbers. In this case, you’ll likely want to convert them to English. Fortunately, Excel makes this very easy. Let’s learn how to convert Arabic numbers to English in Microsoft Excel. 

How to Convert Arabic Numbers to English in Excel

Imagine that you’re sent a list of numbers to work with in Excel. But they’re formatted as Arabic numbers, rather than English. Chances are, you’ll want to convert them to make them easier to read. To get started, let’s look at a series of Arabic numbers in Excel. These are pasted in, and you can make a couple of observations.

For example, click into cell A1, containing the first Arabic number. No matter how the numbers are formatted, Arabic or English, Excel automatically treats them as numerical values. Notice that in the formula bar, you’ll see the English number. However, the cells display Arabic numbers.

Arabic numbers to English Excel

To change the Arabic numbers to English, you’ll need to work on Excel’s Home tab. You’ll find this on the ribbon, the series of menus and tabs at the top of the Excel window. Just right of center, you’ll see the Cell Format dropdown menu.

The dropdown should read Custom with Arabic numbers in place. This is how Excel customarily treats special characters.

Convert Arabic numbers to English in Excel

To change Arabic numbers to English, click on the Cell Format dropdown. Then, click Number from your list of options. You’ll see Excel convert the numbers instantly. You can work cell by cell, or select multiple cells to make the change.

How to convert arabic numbers to English in Excel

As you can see, it’s easy to convert Arabic numbers to English in Excel. This is a quick and easy way to make numbers work well for you, in just seconds.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Expected shortfall formula ExcelExpected Shortfall in Excel
Next Post:Clear Formats in ExcelHow to clear formats in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top