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.

Converting From Numbers to Text

by Allen Wyatt
(last updated September 4, 2014)

54

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:

  1. Select the cells you want to convert.
  2. 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.)
  3. Make sure the Number tab is selected. (See Figure 1.)
  4. Figure 1. The Number tab of the Format Cells dialog box.

  5. In the list of formatting Categories, choose Text.
  6. Click on OK.
  7. Press Ctrl+C. This copies the cells you selected in step 1.
  8. Choose Paste Special from the Edit menu. Excel displays the Paste Special dialog box.
  9. Choose the Values radio button.
  10. Click on OK.

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.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Changing Tabs Using the Ruler

Need to adjust the position of tab stops in a paragraph? One simple way to do it is to just drag them around on the ruler.

Discover More

Adding Ampersands to Custom Dictionaries

It appears that Word doesn't allow you to define custom dictionary entries that include ampersands. There are ways you can ...

Discover More

Separating Cells Based on Text Color

If the font color used for the data in your worksheet is critical, you may at sometime want to move cells that use a ...

Discover More

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!

More ExcelTips (menu)

Using an Exact Number of Digits

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

Discover More

Replacing Cell Formats

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

Discover More

Automatically Copying Formatting

It'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
Subscribe

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

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is two less than 2?

2017-07-07 10:30:26

Guy Dupont

Many thanks for explaining the TEXT worksheet function! (Excel itself does it not, unfortunately)
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

@CHOW<
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

@Beatriz,
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

I need to change the fifth character in a line filled with numbers, to read a letter.

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

This is just a display setting, not a data type change. So vlookups, hlookups, and index/match formulas will still fail when the value is a number in one cell but a string in another cell.


2016-11-09 19:13:29

Coastal Evie

I tried to use =TEXT(cell number, "#,##0.00") to convert a numerical dollar amount into text. This formula does not work on open office; any suggestions?


2016-09-07 10:49:10

AL

could you take this tip one step further, and explain how to preserve leading zeros when converting from fixed length number to text? the only thing that works for me is to copy the column to notepad, format a column at text and copy from notepad back to excel


2016-08-25 04:35:20

islam

Please I Need Your Help

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

SUBRAT KUMAR PATTANAYAK

Dear sir,

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

Thank you!!! This =TEXT(A2, "0") function saved my sanity!
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

Dear Sir,

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

Hello Mervyn, I know two ways to get what you want
-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

Sir,

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

sir ,
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

@Dinesh Rawat,
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

hi

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

@nabajyoti das,
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

Dear Sir,

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

@SYED ESAK,
@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

T UMAMAHESHWAR RAO

sir ,
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

@Sonu Bhanushali,
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

Dear Sir,

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

Manoj Falak

Sir, want the formula of cell A1 is Date 21th march 2014 is to be converted as 'twenty first march two thousand forteen" in cell B1.


2015-10-02 05:32:46

Michael (Micky) Avidan

@Yogini & Rohiz,
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

Dear Sir,

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

We have a Invoice format, where i want numeric total value to directly convert to alphabetic total value, in the below cell of the numeric total.

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

@Praveen Kumar,
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

Hi Can anyone help me this out ?

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

Dear Sir,

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

Sir, want the value of cell A1 is some amount 20,000 to be converted as 'twenty thousand " in cell B1. once i enter the numaric letters in cell A1.


2015-06-03 12:16:51

stcatubag@profriends.com

@SARATH
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

@Micky
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

Sir, 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-04-29 18:08:47

Talha Farooq

hi, it is possible to form developer bottom how much time i needed.

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

Hi Allen

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

Sir, 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-01-03 09:09:36

Hrushikesh

Sir, want the value of cell is some amount like 97,200 to be converted as 'Ninety Seven Thousand Two Hundred", once i enter the numaric letters in any cell.


2014-12-28 10:06:30

Michael (Micky) Avidan

@RANJIT KAKATI,
@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

Hello Sir,

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

Sir, want the value of cell A1 is some amount 191641 to be converted as 'One lakh ninety one thousand six hundred forty one" in cell B1. once i enter the numaric letters in cell A1.


2014-11-09 02:20:13

Francis

Sir, 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.


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

@Steve N,
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.

I have found that after Allen's step 5, you can just press the F2 key (edit mode), make no changes and then press enter. The value of the cell will behave and act as if it were just text.

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

Usually, I use a different approach.

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

Hi Allen, Thanks for this. In my scenario in the same column I had values that were all different types, some alpha some numeric so I just used
= 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

Dear Sir,

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

Regards


This Site

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.

Newest Tips
Subscribe

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

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.