how do I convert numeric data to words?
I am trying to to convert numeric data to words. Example: 5.5 to five and
one half. I recall reading somewhere that this can be done with a macro of some type, unfortunatly I don't recal where I read this. |
how do I convert numeric data to words?
How to Convert a Numeric Value into English Words
http://support.microsoft.com/default...N-US;Q213360&; -- Gary's Student "azohawk" wrote: I am trying to to convert numeric data to words. Example: 5.5 to five and one half. I recall reading somewhere that this can be done with a macro of some type, unfortunatly I don't recal where I read this. |
how do I convert numeric data to words?
have a look at http://www.excelforum.com/showthread.php?t=489756 http://www.xldynamic.com/source/xld.xlFAQ0004.html http://support.microsoft.com/default...B;EN-US;213360 -- mudraker ------------------------------------------------------------------------ mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473 View this thread: http://www.excelforum.com/showthread...hreadid=552083 |
how do I convert numeric data to words?
That was exactly what I was looking for. Thank you.
I had to tweak it a little for my purpose since I wasn't daling with money. But, it was only a few minor changes. "Gary''s Student" wrote: How to Convert a Numeric Value into English Words http://support.microsoft.com/default...N-US;Q213360&; -- Gary's Student "azohawk" wrote: I am trying to to convert numeric data to words. Example: 5.5 to five and one half. I recall reading somewhere that this can be done with a macro of some type, unfortunatly I don't recal where I read this. |
All times are GMT +1. The time now is 04:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com