How to Convert Text to Number or Number to Text in Excel 365?
Tags: converttexttonumbero, kutoolsexceltutorial, kutools
Published: 2020-10-20 12:14:55

---
title: How to Convert Text to Number or Number to Text in Excel 365?
published: true
date: 2020-10-20 10:18:02 UTC
tags: ConvertTexttoNumbero,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-convert-text-to-number-or-number-to-text-in-excel-365/
---

In this article, we are going to see the steps to **Change Text to Number or Number to Text in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Convert Text to Numbers:

To convert text to numbers in the spreadsheet, follow the below steps.

- Firstly, you need to **select a range** that contains the text.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-23.png)<figcaption id="caption-attachment-16064">Example</figcaption>

- On the **Kutools Tab, select** the **Content** option, **choose** the **Convert between Text and Number** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Kutools-Tab.png)<figcaption id="caption-attachment-16066">Kutools Tab</figcaption>

- It will open the Convert **between Text and Number Dialog box.**
- In that dialog box, you need to **select** the **Text to Number** option and **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Click-OK-button.png)<figcaption id="caption-attachment-16067">Click OK button</figcaption>

- Now, you can see that the text values have been converted to numbers as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Result-29.png)<figcaption id="caption-attachment-16068">Result</figcaption>

## Steps to Convert Numeral to Text:

If you want to convert numbers into text values, do the below steps.

- You need to **select a range** that contains the text.

![Sample data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-18.png)<figcaption id="caption-attachment-16070">Sample data</figcaption>

- On the **Kutools Tab, select** the **Content** option, **choose** the **Convert between Text and Number** option from the menu.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Kutools-Tab.png)<figcaption id="caption-attachment-16066">Kutools Tab</figcaption>

- It will open the **Convert between Text and Number Dialog box.**
- In that dialog box, you need to **select** the **Number**  **to Text** option and **click** the **OK** button.

![Press the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-16.png)<figcaption id="caption-attachment-16071">Press the OK button</figcaption>

- Now, you can see that the numbers have been converted to text values as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-36.png)<figcaption id="caption-attachment-16072">Output</figcaption>

## Conclusion:

In the above article, you can easily understand the steps to **Change Text to Number or Numeral value to Text in Excel Office 365** using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Convert Numbers to Ordinal Numeral in Excel Office 365!!](https://geekexcel.com/convert-numbers-to-ordinal-numeral-in-excel-office-365/)
- [How to Convert Days to Years, Months, and Days in Excel 365?](https://geekexcel.com/how-to-convert-days-to-years-months-and-days-in-excel-365/)