Convert Number to Text

[AnalystDBA]

Hi People,

Does anyone know of a function or have a function that they have created that will convert a number to its text equivilant.

ie Number = 1240
Text = One Thousand Two Hundred and Forty

Cheers,
AnalystDBA

 

[dougcranston]

There are a couple sites with code snippets that might help you on this.

The first is:
"Convert currency numbers into text "

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=520&lngWId=1

"VB: Number To Words - tear it up! "

http://www.vbcity.com/forums/topic.asp?tid=6785

Hope this helps.

BTW search string I used was: vbscript convert number to words

Thanks,

doug cranston

 

[andrew299]

This is the most recent quuestion and it solved the problem

thread707-490731 It may have hit every branch on its way out of the ugly tree, but hey! It works. (but don't quote me on that)