Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to convert number to text string?

Status
Not open for further replies.

etalentweb

Technical User
Jun 14, 2006
5
US

How can I convert a number, say 840.21, to "EIGHT HUNDRED FORTY AND 21/100 DOLLARS" ?
 
Which version of FM ?

In lower than 7 you need a 'monster' calculation, in 7/8 Dev/Adv you could use a Custom Function.

If you have 7/8 'regular' you could ask a Dev/Adv owner to implement the function in your app. or tweak the calc from the function into your app.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top