Home |
Search |
Today's Posts |
#1
|
|||
|
|||
convert numbers to text.
I am working on a job proposal the requires the price be written out like a
check. Is there any way to make this work. example price= $1244.00 and text version is "One thousand two hundred forty and 00/100---------" |
#2
|
|||
|
|||
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH Bob Phillips "tech1pc" wrote in message ... I am working on a job proposal the requires the price be written out like a check. Is there any way to make this work. example price= $1244.00 and text version is "One thousand two hundred forty and 00/100---------" |
#3
|
|||
|
|||
This file might be a help:
http://www.bygsoftware.com/examples/...s/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 - "tech1pc" wrote in message ... I am working on a job proposal the requires the price be written out like a check. Is there any way to make this work. example price= $1244.00 and text version is "One thousand two hundred forty and 00/100---------" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
How to reformat numbers stored as text (apostrophe at beginning) | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
convert number to text and format it. | Excel Worksheet Functions | |||
Convert text to numbers | Excel Discussion (Misc queries) |