Question about Computers & Internet
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"
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
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.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 07, 2014 | Computers & Internet
Apr 29, 2010 | Microsoft Office Excel 2007
Jan 19, 2009 | Microsoft Excel for PC
Dec 15, 2008 | Microsoft Windows XP Home Edition
Nov 18, 2008 | Microsoft Windows XP Home Edition
Feb 08, 2008 | Computers & Internet
127 people viewed this question
Usually answered in minutes!