When I create an event, I click on an approximate time during the day when I want the event to occur, then I click "edit event detail...
9 hours 42 minutes ago by bessellbrowne on Google Calendar gets 'smart' rescheduling
We have relaunched: What's new at ZDNet Asia?
ZDNet / Insight / Software / Story
Changing numbers into words in Excel
Summary
Microsoft Excel does not ship with a function that will convert a numeric value into English words. However, there is a user-defined function that will perform that service.
Events
Microsoft MSDN/Developer Event
25 Mar 2010
One Marina Boulevard, Microsoft Singapore
IT Architect Regional Conference Singapore 2010
20 - 21 Apr 2010
Singapore Management University, Singapore
The Internet Show 2010
21-22 Apr 2010
Suntec Singapore
For whatever reason, Microsoft Excel does not come with a built-in function that will convert numeric values into English words. The ability to make such a conversion is necessary for the successful operation of several potential Excel applications. This is the dilemma that faced karansoin when he/she asked for help in the TechRepublic Technical Q&A forum.
Solution
Microsoft has published a rather lengthy user-defined function that will perform this conversion. To apply the function to your worksheet, you open the Excel Visual Basic Editor, which is found in the Tools | Macros menu. After opening the editor, open a new module by navigating to Insert | Module in the menu toolbar.
Once you're in a blank module, you should copy the code in Listing A to the Windows clipboard and paste it into the module. (See Figure A.)
Figure A
Code snippet
An example
Once the code is in place and you save it in the current worksheet, you'll have access to the SpellNumber() function, which will convert to English any value passed to it. This user-defined function comes in handy for several applications, including our example—printing a check. Figure B shows a simple check writing worksheet that takes the information input into A2, B2, and C2 and places it in the corresponding cells that make up our printable check.
Figure B
Check printing
The key to the example is the SpellNumber() function located in cell C13. With some layout adjustments configured for your particular laser printer and the use of micro-encoding toner, you could conceivably use this worksheet to print checks. Of course, there is still plenty of room for improvement to the worksheet in terms of linking to customer information, accounts payable, check registers, etc., but the basic concept is sound.
Solution
Microsoft has published a rather lengthy user-defined function that will perform this conversion. To apply the function to your worksheet, you open the Excel Visual Basic Editor, which is found in the Tools | Macros menu. After opening the editor, open a new module by navigating to Insert | Module in the menu toolbar.
Once you're in a blank module, you should copy the code in Listing A to the Windows clipboard and paste it into the module. (See Figure A.)
Code snippet
An example
Once the code is in place and you save it in the current worksheet, you'll have access to the SpellNumber() function, which will convert to English any value passed to it. This user-defined function comes in handy for several applications, including our example—printing a check. Figure B shows a simple check writing worksheet that takes the information input into A2, B2, and C2 and places it in the corresponding cells that make up our printable check.
Check printing
The key to the example is the SpellNumber() function located in cell C13. With some layout adjustments configured for your particular laser printer and the use of micro-encoding toner, you could conceivably use this worksheet to print checks. Of course, there is still plenty of room for improvement to the worksheet in terms of linking to customer information, accounts payable, check registers, etc., but the basic concept is sound.
| Next Steps: Build your skills with these hand-picked resources |
MSKB 213360-XL2000: How to Convert a Numeric Value into
English Words
|
|
MSKB 140704-
How to Convert a Numeric Value into English Words
|
|
Microsoft Visual Basic
for Applications home page
|
|
Sort and format a protected Excel worksheet with a
macro
|
Transform your business interactions with real-time voice, video and telepresence solutions.
Tech Vendor: Cisco
Tech Vendor: Cisco
ZDNet Asia Live
ipads break alott i had one it broke three times in the month i had it so i got rid of the damn thing id just go for the laptop Top Grade...
9 hours 44 minutes ago by bessellbrowne on Report: 'Hundreds of thousands' of iPad preordersThere are a number of websites that still require Internet Explorer to view and IE for Mac Stinks (it is really ies4osx which is the Wind...
9 hours 46 minutes ago by bessellbrowne on Microsoft: Only minor tweaks in Windows 7 SP1The receivers don't transmit back to the satellite. Unless there is a phone line attached to the receiver, they don't have any wa...
9 hours 48 minutes ago by bessellbrowne on Apple to join the geolocation craze?What to expect from open source Symbian http://is.gd/aPIGL
10 hours 4 minutes ago by rebelk0de on topsy"Lead Cognos BI Developer Insurance in New South Wales , Australian ..." http://bit.ly/ayy19L
10 hours 43 minutes ago by rhrcognos on topsywhatever little understanding I have we 'll only progress toward end of the world if we use HPCs to lenthen life of human being. Huma...
19 hours 55 minutes ago by abhi32002@gmail.com on High computing promises elixir of lifeThanks for the knowledgeable article on SDDs. Allas...when all this reasearch will happen in Indian Universities. Hope the new bill on Fo...
20 hours 8 minutes ago by abhi32002@gmail.com on APAC HPC users eye solid-state drivesIt was a good article. This brings a good opportunity for Indian IT firms to come up with new solutions in this field. HPC can become a b...
20 hours 26 minutes ago by abhi32002@gmail.com on High computing most-wanted job in AsiaCOL KR DHARMADHIKARY(RETD) its very late to reply the link, but if it is still alive and looking for opportunity, i would like to know th...
1 day 24 minutes ago by deb021280 on Education takes off in rural India, helped by PCsIt was just a matter of time until google was marginalised anyway. I'm afraid this will be forgotten in China very quickly. Still, it...
1 day 29 minutes ago by robinsmith on Report: Google to leave China on April 10
High performance computing (HPC) most-wanted job in Asia http://bit.ly/9vFC3i (via @zdnetasia) #singapore
1 day 40 minutes ago by mySingapore on twitterHe doesn't care if her shoes are of glass, All he wants to see is a huge rack and nice a*s. Sleeping beauty's not awoken by true ...
1 day 57 minutes ago by warlowdavies on One pair of 3D glasses to rule them all
RT @zdnetasia: EMC COO, Pat Gelsinger, on bridging gaps in the organization and its cloud ambitions in Asia. (cont) http://tl.gd/i5jjd
1 day 29 minutes ago by mistymaitimoe on twitter
EMC COO, Pat Gelsinger, on bridging gaps in the organization and its cloud ambitions in Asia. http://bit.ly/9etOZW
1 day 33 minutes ago by zdnetasia on twitter
Asian SMBs need to pay more attention to disaster recovery planning http://bit.ly/bDet08 via @zdnetasia
1 day 49 minutes ago by asiapacsolution on twitterAsian SMBs need to pay more attention to disaster recovery planning http://bit.ly/bDet08
1 day 4 minutes ago by zdnetasia on twitter
[TECH] URL Shorteners slow Web redirection. - http://bit.ly/bySnWK @zdnetasia
2 days 47 minutes ago by danielcktan on twitter
URL shorteners are great but they can slow web redirection & you pray it would never go down http://bit.ly/bySnWK via @zdnetasia
2 days 15 minutes ago by angahsin on twitterTemasek Holdings eyeing tech stocks, indicating optimistic outlook on IT sector. http://bit.ly/aM7VwU
2 days 43 minutes ago by zdnetasia on twitterURL shorteners slow Web redirection. http://bit.ly/bySnWK
2 days 43 minutes ago by zdnetasia on twitterChinese agencies cry foul over Google. http://bit.ly/by6rwV
2 days 50 minutes ago by zdnetasia on twitterPhilippine antipiracy drive focuses on enterprises. http://bit.ly/aWryDC
2 days 11 minutes ago by zdnetasia on twitterGartner: China to become world's fastest-growing enterprise software market. http://bit.ly/bqJTtb
2 days 12 minutes ago by zdnetasia on twitterall of sg's isps have been practising compulsory invisible proxy for all home subscribers at their backend since many years back alre...
2 days 7 minutes ago by melvinchia on Web filters mean bad news for businessit is not to good for china.
Proactol
RT @zdnetasia: HP touts new products and management and productivity tools to address business computing pain points. http://bit.ly/dudgA6
2 days 23 minutes ago by LiruChan on twitterFor those with a computer science background, or interested in the high performance computing scene: http://bit.ly/9vFC3i
2 days 48 minutes ago by zdnetasia on twitterHP touts new products and management and productivity tools to address business computing pain points. http://bit.ly/dudgA6
2 days 55 minutes ago by zdnetasia on twitterIT security insiders rob casinos of $50K http://is.gd/aPIKR
2 days 24 minutes ago by rebelk0de on topsyVery good explanation of JMX
3 days 57 minutes ago by Babith B on Managing applications with JMXThe reaction to a report issued Tuesday by Flurry Analytics managed to completely overlook some interesting news--the Android-based Motorola Droid outsold the original iPhone over the same period of time following their respective launches--to focus instead on the sales numbers for the Nexus One.
3 days 1 minute ago by lonemavericks on diggsAnother ZTE story....
3 days 3 minutes ago by Moderate Your Greed on Philippines opens bid for final 3G licenseWe at www.fifosys.com have also seen a growth in IT outsourcing and anticipate it as a growing field.
3 days 36 minutes ago by sarah Jane on Companies' outsourcing spend to increaseKeep up with ZDNet Asia
Linkedin 
RSS Feeds 
Newsletters 
Twitter Inside ZDNet Asia
Sponsored
The Desktop Virtualization Revolution is here!
Find our more with Citrix Simplicity is Power
2010 IT Salary & Skills Report
Find out the salary range of IT professionals. Join activeTechPros for free access to the report.
The Internet Show 2010, 21-22 Apr 2010, Singapore
FREE admission for visitors who pre-register online. Register Today!
This innovation is really great!! then there is the proverbial BUT ....
I need the currency in pesos instead of dollar; centavos instead of cents. and the words "and" into a "&".
can you please help me convert it?
Thank you very much.
Sincerely, Afs
PS: no reviews yet on the SE P910? I can't find it under handphones nor under handhelds. And do you guys know when the SE S700 is exactly coming out? Thanks again.