Loading

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.

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.

Learn more about Allen...

ExcelTips FAQ

ExcelTips Resources

Ask an Excel Question

Make a Comment

Free Business Forms

Free Calendars

** 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),

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.

*Related Tips:*

**Comprehensive VBA Guide** Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out *Mastering VBA for Office 2010* today!

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.

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?

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

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

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

Dear sir,

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

5,117 (Five Thousand One Hundred Seventeen)

100 (Hundred)

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

5,117 (Five Thousand One Hundred Seventeen)

100 (Hundred)

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!

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!

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.

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.

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.

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

Sir,

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

Please assist...

Thank you.

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

Please assist...

Thank you.

sir ,

i want to convert a number to text

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

i want to convert a number to text

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

@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

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

Dear sir,

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

5 five

100 hundred

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

5 five

100 hundred

hi

i would like to know following comemnts

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

i would like to know following comemnts

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

@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

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

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

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

1, one

12 twelve

200 two hundred

5010 five thousand ten

@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

@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

pl how to convert numeric to text

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

i want to convert a number to text

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

thanq

@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

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

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

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

1, one

12 twelve

200 two hundred

5010 five thousand ten

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.

@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

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

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

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

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

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

@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

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

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?

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?

Dear Sir,

I need to convert 500.00 to five hundred repees.

I need to convert 500.00 to five hundred repees.

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.

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.

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.

@SARATH

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

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

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

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

@Micky

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

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

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.

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.

For example:

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

want to convert no into text in excel

600=text automatically???

600=text automatically???

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

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

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.

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.

@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

@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

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.

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.

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.

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.

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

@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

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

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.

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.

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

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

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. :)

= 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. :)

sir ms excel 2003 me convert number to text bataiye

Dear Sir,

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

Regards

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

Regards