# EXCEL HOW TO CONVERT NUMBERS TO WORD IN EXCEL

Posted by on

• Level 1:

An expert who has achieved level 1.

• Contributor

You will need to write a Macro that questions each position and turns it into a word depending on it's value ...

Something like :

DIM WordValue as String
DIM LenghtIndex as integer

FOR lenghtindex = 1 to Len(ExcelCellValue) DO

CASE StrCpy (Number, LenghtIndex , 1)
1 : WordValue = WordValue & "one"
2 : WordValue = WordValue & "two"
3 : WordValue = WordValue & "three"
4 : WordValue = WordValue & "four"
END CASE

END FOR

If you want it to realy say fourthy four when the value is 44 instead of have it say "four four" you need to question the position. If it's in second position starting from left it will be fourty , if it's in third place it will be fourhundred ... etc

Posted on Aug 29, 2008

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### FORMULA PROBLEM IN MS EXCEL

The cells you are trying to sum are probably text and not numeric values. Format them as number or convert them to numbers.

Apr 18, 2009 | Microsoft Office Excel 2003 for PC

### Convert figures to numbers on Mac

The easiest I can think of converting numbers into text in 2 colums is using a LOOKUP function in Excel. I have no knowledge of the range of numbers you are working with though so it may sound easier than it is...

Mar 25, 2009 | Apple Computers & Internet

### How to convert numbers into words in MS excel?

Hi there

Start typing with single apostrophe ( ' )

Means you can use ' as a prefix to start typing the numbers.

Regards

Jan 19, 2009 | Microsoft Excel for PC

### Need Formula

TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. \$
SQL Database Migration \$
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! \$
CSV Converter \$

IMPORTING
Import SQL Into Excel-SQL Tester \$
Import Excel Into Access \$

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

### CONVERSION OF NUMERICAL VALUE INTO TEXT IN M.S. EXCEL

to convert numbers into text, just add an apostrophe ' to the left of the number. When you press enter, the apostrophe will no appear, but the number will have the atrtibutes of text

Nov 18, 2008 | Microsoft Windows XP Home Edition

### How to convert a pdf file in excel

Dear Gatta,
for this conversion you have to install Adobe Professional 7 Version in your computer . by this software you can convert any Word and Excel file in to PDF and vice versa.

Takecare

Mar 25, 2008 | Computers & Internet

### Excel 2007: number formatting

Genny....

Let me give you some basic info first. Information within a cell is discreet. You can add to it...the \$ sign as an example...with functions (actual code which equals a program) embedded in Excel or you can type it in.....but you would have to create an actual program to do what you would like to do.

I don't use your version of Excel but I am extremely confident you cannot do what you would like to do. Sorry....Tango.

Feb 08, 2008 | Computers & Internet

## Open Questions:

#### Related Topics:

127 people viewed this question

Level 3 Expert

Level 3 Expert