simple formating Question

[cyote101]

Hello all,

I was wondering if it is posible to convert numbers in the text, using a fomula.

for example $900.00 to " Nine Hundred Dallors" or 45.98 to Forty Five Dallors and ninetyCeight cents

so please let me knows, thanks

 

[HalfAce]

Hello cyote101,
A couple of links that might be of interest...
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q213360
http://www.mrexcel.com/board2/viewtopic.php?t=136960
http://www.mrexcel.com/board2/viewtopic.php?t=32633

Hope it helps.

 

[HalfAce]

Just occurred to me that ASAP Utilities has a cool function for this also.
(Select your range of interest > ASAP Utilities from your menu (after you've downloaded it of course.) Numbers > Spell numbers or amounts.)

You can download it (for free) at:
http://www.asap-utilities.com/

Lots & lots of cool stuff in there to make life easier.