**Please Note: **
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), *this tip may not work for you*. For a version of this tip written specifically for later versions of Excel, click here: Converting From Numbers to Text.

Jocelyn asked if there is a way to easily convert numbers to their text equivalent. For instance, to convert the numeric value 6789 to the text digits "6789."

There are multiple ways that you can approach this problem. One way is to simply specify to Excel that the cells should be treated as text. Display the Format Cells dialog box and then on the Number tab make sure that Text is selected. Any selected cells are then formatted as if they were text, and are moved to the left side of their cells (unless you have some other alignment format specified).

The applicability of this solution, however, depends on the version of Excel you are using. In some versions it will work as described here, but in others it may not. There is another thing you can try, however:

- Select the cells you want to convert.
- Choose Cells from the Format menu. Excel displays the Format Cells dialog box. (To display the dialog box in Excel 2007, display the Home tab of the ribbon, click Format in the Cells group, and then choose Format Cells.)
- Make sure the Number tab is selected. (See Figure 1.)
- In the list of formatting Categories, choose Text.
- Click on OK.
- Press
**Ctrl+C**. This copies the cells you selected in step 1. - Choose Paste Special from the Edit menu. Excel displays the Paste Special dialog box.
- Choose the Values radio button.
- Click on OK.

** Figure 1.** The Number tab of the Format Cells dialog box.

Another thing you can do is to use the TEXT worksheet function. Let's say you have the value 6789 in cell A7. In cell B7 you could place the following:

=TEXT(A1, "#,##0.00")

This usage of TEXT results in a text digits that have the thousands separator in the right place and two digits to the right of the decimal point, as in "6,789.00". You can specify, as the second parameter to TEXT, any formatting desired. If you want the number converted to text without any special formatting, you can use the following:

=TEXT(A1, "0")

The result is the textual equivalent of an integer value.

*ExcelTips* is your source for cost-effective Microsoft Excel training.
This tip (2680) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: **Converting From Numbers to Text**.

**Solve Real Business Problems** Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out *Microsoft Excel 2013 Data Analysis and Business Modeling* today!

Excel allows you to format numeric data in all sorts of ways, but specifying a number of digits independent of the decimal ...

Discover MoreNeed to replace the formats applied to some cells with a different format? Those using Excel 2003 will find it easy; those ...

Discover MoreIt's easy to automatically set the contents of one cell to be equal to another cell. But what if you want to copy the ...

Discover More**FREE SERVICE:** Get tips like this every week in *ExcelTips,* a free productivity newsletter. Enter your address and click "Subscribe."

2017-07-07 10:30:26

Guy Dupont

By applying this function, I am now able to sort series of numbers with suffixes, like 1, 1A, 2, 2A, 2B, 3, etc.

2017-03-03 07:44:20

Michael (Micky) Avidan

Chack this:

https://support.microsoft.com/en-us/help/213360/how-to-convert-a-numeric-value-into-english-words-in-excel

--------------------------

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2017)

ISRAEL

2017-03-03 07:40:56

Michael (Micky) Avidan

Try: =REPLACE(A1,5,1,"X")

--------------------------

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2017)

ISRAEL

2017-03-02 21:12:12

CHOW

i need to convert 14,400.44 to FOURTEEN THOUSAND FOUR HUNDRED AND CENTS FORTY FOUR ONLY

How?

2017-02-14 11:23:55

Beatriz

For example: 35N3O00GM

change it to: 35N3X00GM

2017-02-02 04:49:48

nAND KISHOR SINGH

convert numeric to character

2016-11-14 17:44:17

Jason Erdmann

2016-11-09 19:13:29

Coastal Evie

2016-09-07 10:49:10

AL

2016-08-25 04:35:20

islam

How to Convert currency With Three Decimal Digits

For Example :

125.325 KD

To Be:

One Hundred Twenty Five Dinar & three Hundred Twenty Five Fils Only

Or

One Hundred Twenty Five Dinar & 325 Fils only

2016-08-15 11:43:49

Please let me know how to convert number to word such as

5,117 (Five Thousand One Hundred Seventeen)

100 (Hundred)

2016-08-02 10:31:15

Teresa

I don't know why Excel doesn't just allow a change un formatting, requiring it to be "applied" so to speak. Makes no logical sense, nor does the whole need for this formula because of scientific notation being default in Excel!

2016-07-07 00:47:17

eric

Is there any chance to add/modify belows to make it more perfect?

i. add "-" for double digits like 28 as twenty-eight (instead of twenty eight);

ii. put "and cents .xx only" instead of "and .xx cents only" (also add "ONLY");

iii. like $280, put "And" after Two Hundred, and before Eighty ? Can it simply shows "ONLY" and don't need "No Cents" ? The original is Two Hundred Eighty Dollars and No Cents.

Thanks so much.

2016-06-19 11:11:07

Andrés

-Using Custom Format cells

-Using a macro:

Sub AddZeros()

ActiveCell.NumberFormat = "@" 'Convert activecell into text

l = 6 'length

c = ActiveCell

n = Len(c)

nn = l - n

For i = 1 To nn

c = "0" & c

Next

ActiveCell = c

End Sub

The variable "l" can vary to any number you want.

2016-06-03 05:02:32

Mervyn

I would like to convert the number 123 to the following text value: *00123*

Please assist...

Thank you.

2016-04-29 07:55:44

anitha

i want to convert a number to text

example 225 as two hundred twenty five only. please send me answer to my email.

2016-04-17 06:05:05

Michael (Micky) Avidan

Take a look at my post dated: 28 Dec 2014, 10:06

-----------------------

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2016

ISRAEL

2016-04-16 15:45:54

Dinesh Rawat

Dear sir,

Please let me know how to convert number to word such as

5 five

100 hundred

2016-03-07 01:27:17

sheena

i would like to know following comemnts

how to do v look up, h look up, & converting numeric to words

2016-01-21 11:17:17

Michael (Micky) Avidan

Take a look at my post dated: 28 Dec 2014, 10:06

-----------------------

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2016

ISRAEL

2016-01-20 09:27:23

nabajyoti das

Please tell me that how to convert number to word for example -

1, one

12 twelve

200 two hundred

5010 five thousand ten

2016-01-13 05:27:39

Michael (Micky) Avidan

@T UMAMAHESHWAR RAO,

Check out the following link:

https://support.microsoft.com/en-us/kb/213360

--------------------------

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2016)

ISRAEL

2016-01-13 02:22:50

SYED ESAK

pl how to convert numeric to text

2016-01-09 09:47:00

i want to convert a number to text

example 225 as two hundred twenty five only. please send me answer to my email.

thanq

2015-12-05 07:42:04

Michael (Micky) Avidan

Take a look at my post dated: 28 Dec 2014, 10:06

-----------------------

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2016

ISRAEL

2015-12-05 03:07:10

Sonu Bhanushali

Please tell me that how to convert number to word for example -

1, one

12 twelve

200 two hundred

5010 five thousand ten

2015-10-18 05:50:17

2015-10-02 05:32:46

Michael (Micky) Avidan

Take a look at my post dated: 28 Dec 2014, 10:06

-----------------------

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2016

ISRAEL

2015-10-02 01:28:17

Rohiz

Please tell me that how to convert number to word for example -

1, one

12 twelve

200 two hundred

5010 five thousand ten

i think you understood very well.

thank you

2015-08-19 06:27:05

Yogini

For Ex:

xyz sold 2500

Tax 5% 125

Total 2625

Rupees (in words): _______________

So i want 2625 or whatsoever total is should change to text in below cell of Rupees (in words):

How it can be done?

Suggest me

2015-08-17 07:21:27

Michael (Micky) Avidan

Should the following 3 strings be in one cell or in 3 cells in a row?

------------------------

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2016)

ISRAEL

2015-08-17 01:40:24

Praveen Kumar

In excel I need a set of numbers display automatically as following:

143 as One Four Three

245 as Two Four Five

Is there any formula?

2015-08-10 04:41:12

Anurag Mishra

Dear Sir,

I need to convert 500.00 to five hundred repees.

2015-07-30 07:36:57

vinay t

want the value of cell A1 is some amount 5500 to be converted as 'Five thousand Five hundred" in cell B1. once i enter the numaric letters in cell A1.

2015-07-17 10:18:21

vinayaka.T

2015-06-03 12:16:51

stcatubag@profriends.com

check this link for sample of converting nos. into words in Excel

https://youtube.com/watch?v=gTQiNAk6YxE

2015-05-20 15:14:09

Shah

the tip http://support.microsoft.com/kb/213360/en-us did the trick for converting a number to English words. Thank you!!!

2015-05-19 05:17:01

SARATH

2015-04-29 18:08:47

Talha Farooq

For example:

If I wrote 5 then automatically generated 5 deveolper botton in next row.

2015-02-28 00:47:38

prashant

want to convert no into text in excel

600=text automatically???

2015-02-27 05:05:53

Koketso

In my case i converted numbers to text but somehow excel still recognizes this as numbers...for example when i want to sort the columns, it wants to sort from smallest to largest rather than from A to Z etc

2015-01-19 09:47:58

Prabin Bhandaru

2015-01-03 09:09:36

Hrushikesh

2014-12-28 10:06:30

Michael (Micky) Avidan

@Francis,

@AJay,

Take a look at the following link:

http://support.microsoft.com/kb/213360/en-us

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2015)

ISRAEL

2014-12-27 10:07:06

Basavaraj

Taking your example 6789 for converting from numbers to text, I have another situation can you please help me to solve this below

First I have given manually typed code to the numbers i.e For 6 code is FH, 7 is GI, 8 is HJ, 9 is IK.

In A1 cell is type 6789, it should reflect/display as FH-GI-HJ-IK in B1 cell.

Column A Column B

6789 FH-GI-HJ-IK

7896 GI-HJ-IK-FH

8967 HJ-IK-FH-GI

8888 HJ-HJ-HJ-HJ

9999 formula ?

Please suggest a formula when I enter a number in Column A and code should reflect/Display in Column B

Thanks.

2014-12-25 03:17:23

RANJIT KAKATI

2014-11-09 02:20:13

Francis

2014-11-03 02:10:01

AJay

I want the value of cell C2 is 1500 to be converted as 'One thousand five hundred" in cell C5

2013-11-20 05:18:14

Michael (Micky) Avidan

There is a very famous saying: "all roads leads to Rome" - but most people will take the fastest/shortest route.

Same in "Excel".

If you will try my suggestion and count its steps - I'm sure that also you will easily decide which procedure you're going to use in the future.

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2014)

ISRAEL

2013-11-19 08:08:57

Steve N.

That only works for one number at a time. If you are trying to apply this to multiple cells, there is not a true one cell fix. If you don't want to spend the time repeating the F2>enter repair multiple number of times, I'd then follow the rest of Allen's solution.

2013-11-18 07:23:57

Michael (Micky) Avidan

Select the range of cells > goto the menu 'Data' > 'Text to Columns' > 'Next' > 'Next' > select the "TEXT" radio button > 'Finish'.

Michael (Micky) Avidan

“Microsoft® Answers" - Wiki author & Forums Moderator

“Microsoft®” MVP – Excel (2009-2014)

ISRAEL

2013-11-17 11:28:06

Lois

= TEXT (A1,"#")

thanks for the tip. this was a great solution to a column where I couldn't use the "Convert to number" pop up because of the differnt data types. Hours of my life saved. :)

2013-05-23 06:41:16

vijay kumar

sir ms excel 2003 me convert number to text bataiye

2012-12-04 01:29:26

Ahmed

Thanks for you help and what i need is to convert for example 570.00 to Five Hundred Seventy Dollars Only

Regards

Got a version of Excel that uses the
menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)?
**This site is for you!** If you
use a later version of Excel, visit
our *ExcelTips* site focusing on the ribbon interface.

**FREE SERVICE:** Get tips like this every week in *ExcelTips,* a free productivity newsletter. Enter your address and click "Subscribe."

Copyright © 2017 Sharon Parq Associates, Inc.

## Comments