answersLogoWhite

0

You can do it on a limited amount, but as the amount of numbers are infinite, it is impossible to do it for all numbers. You could do the ten digits but when you combine digits the words change. So you can get "two" and "zero", but putting them together is "twenty" not "two zero", so it is complicated. You can do the digits using If functions or you could do it using one of the lookup functions, such as VLOOKUP.

Put the digits 0 to 9 in the cells A2 to A11. Then put the word for each digit in the cells B2 to B11.

In cell B13 enter this formula:

=VLOOKUP(A13, A2:B11,2)

Then in cell A13 type any digit, and in cell B13 the correct word will appear.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What do one do in order to excel?

please copy in ms word. then convert it


What do Excel convert all formulas from?

Excel does not convert formulas from anything. Formulas are displayed as you enter them in cells. [[What do excel convert all formulas from#ixzz15yaIeMD4|]]


How do you convert time in Excel?

There are a number of functions in Excel that can manipulate time values. The TIME function and the TIMEVALUE function may be the ones that are most useful. It depends on what you want to be able to do, when you say "convert time".


What does Excel convert all formulas from?

Excel does not convert formulas from anything. Formulas are displayed as you enter them in cells.


How do you Convert Tally 7.2 xml data into Excel Format?

tally 7.2 data convert into excel


How do I convert PDF files to excel?

To convert PDF files to an Excel file, you can use this website, http://www.pdftoexcelonline.com/. This website can convert any PDF file to any Excel file for free.


Where do I go to convert my PDF files to excel?

PDF-to-Excel online converter and Adobe Acrobat X are two programs that allow you to convert the PDF files to Excel. CNET also offer free download from Blue Label Soft.


How do you convert an xls file to xlt?

Open in Excel and save as an Excel Template.


How do you convert Excel to csv in Microsoft Excel?

From within Excel, File Menu>Save As>Save As Type>CSV


How to convert Excel to PDF?

Visit EditPDF123


How do you convert degrees into slope in Excel?

To convert 'D' degrees into a percent slope, you could use the Excel formula:= 100 * TAN ( D / 57.296 )


How do you import data from word to Excel?

You do not really import data from Word, but you can cut and paste from Word to Excel. If you like, you can embed the word document in an Excel worksheet.