Question about Computers & Internet

1 Answer

EXCEL HOW TO CONVERT NUMBERS TO WORD IN EXCEL

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 3 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

How Ca I Import Excel Contacts into vCard?


The free Opal-Convert Excel to vCard to Excel might work for you. Opal Convert Excel to vCard to Excel

Nov 07, 2014 | Computers & Internet

Tip

How to convert excel to PDF


According to a recent report,Adobe estimates that there are about 300
million PDF in circulation,the amount and use of PDF format is still growing exponentially.People nowadays cannot live without PDF files.
Sometimes,you need to convert excel to pdf files,but how to convert excel spreadsheets to pdf with retains all the features of the original excel file?

you will need pdf converter to convert excel to pdf.

1.Run the pdf converter program.

2.Add PDF files,specify output folder.

3.Start conversion.

Note: you cn add PDF properties to the output PDF file, like author, passwords, allowed actions, etc.

on Mar 08, 2010 | Computers & Internet

2 Answers

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

1 Answer

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

1 Answer

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

1 Answer

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

3 Answers

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

1 Answer

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

2 Answers

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

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

126 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...