How to Convert Non-Numeric value to Numeric in Microsoft Excel 2013?

This article will explain how to convert a simple alphanumeric value to numeric value in Microsoft Excel 2013.

There are times when the users may need to convert a non-numeric value (for example Yes or No) to its Numeric value when using Microsoft Excel Spreadsheet. Microsoft Excel 2013 offers an easy way to evaluate an Non numeric value using simple formula and display its numeric equivalent.

How to Convert Non-Numeric value to Numeric in Microsoft Excel 2013?

To translate the non-numeric value to numeric value in Microsoft Excel, follow the below steps

1. Launch Microsoft Excel 2013 and create a blank workbook or open an existing workbook.

2. Navigate to the Formula’s tab and from the “More Functions” dropdown button, select, Information -> “N”.

How to Convert Non-Numeric value to Numeric in Microsoft Excel 2013?

3. This will display the Functions Argument Dialog. Enter the non-numeric value. For example – TRUE. This will display numeric the value of true.

How to Convert Non-Numeric value to Numeric in Microsoft Excel 2013?

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

Event on Building intelligent bots with the Microsoft Bot Framework in Manchester
Want to learn about building intelligent bots using Microsoft's Bot Framework. Here's an interesting...
How to find the Created and Last Modified time in Microsoft Excel ?
You can easily find out the exact date and time when the excel workbook was created and modified usi...
How to copy multiple sheets in Excel?
There are scenarios where you might want to make a copy of multiple worksheets in a workbook in Micr...