howto convert a number into words like 10 to ten

K

kaushik

i want to print numbers entered as numbers in words like 1 is one,20 as
twenty also to have two decimal places
 
K

kaushik

Thanks Andy I think this will do the job

Andy Wiggins said:
This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
writing routines.

The code is open and commented.


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
Click to expand...
 
I

Ibrahim

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Excel does not accept text format! 0
Word- Find and Replace 1
How can the font and size of (all) citation numbers be altered? 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Space at end of multi page list to accommodate new entries 1

Top