i want a function by which i can convert the calculated figuers in spelling
say for e.g if in my invoice file the amount comes to 127367.25 .i hav eto
write the complete amount in words.is there any formula,function which can
derive the amount in words as in above e.g. convert Amount of 127367.25 to
words as one lack twenty seven housand three hundred sixty seven and twenty
five paise.

Search microsoft.com for "spell number". You'll wind up at
http://support.microsoft.com/default...b;en-us;213360

"nimesh.kothari" wrote:

i want a function by which i can convert the calculated figuers in spelling
say for e.g if in my invoice file the amount comes to 127367.25 .i hav eto
write the complete amount in words.is there any formula,function which can
derive the amount in words as in above e.g. convert Amount of 127367.25 to
words as one lack twenty seven housand three hundred sixty seven and twenty
five paise.

Hi

Have look he
http://groups.google.co.uk/group/mic...44fdf1bf90703f

This thread seems to cover most of the options!

Andy.

"nimesh.kothari" wrote in message
...
i want a function by which i can convert the calculated figuers in spelling
say for e.g if in my invoice file the amount comes to 127367.25 .i hav eto
write the complete amount in words.is there any formula,function which can
derive the amount in words as in above e.g. convert Amount of 127367.25 to
words as one lack twenty seven housand three hundred sixty seven and
twenty
five paise.