ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to convert 100 in figuers to one hundred in spelling (https://www.excelbanter.com/excel-discussion-misc-queries/77989-how-convert-100-figuers-one-hundred-spelling.html)

nimesh.kothari

how to convert 100 in figuers to one hundred in spelling
 
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.

bpeltzer

how to convert 100 in figuers to one hundred in spelling
 
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.



how to convert 100 in figuers to one hundred in spelling
 
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.





All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com