View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] bplumhoff@gmail.com is offline
external usenet poster
 
Posts: 136
Default HOW CAN I CONVERT A NUM IN WORDS (EXCEL)

Hello,

That function returns for:
9999999999999990 Nine Dollars And Ninety Nine Cents
0.123 No Dollars And Twelve Cents
-1 One Dollar And No Cents
20.123 Twenty Dollars And Twelve Cents
-20.123 Hundred Twenty Dollars And Twelve Cents
1.01 One Dollar And One Cent
1000001.01 One Million One Dollars And One Cent

That means:
a) It does not check for boundaries (too big numbers)
b) It cannot handle negative numbers
c) It does not tell anything about rounding

I suggest to take my function spellnumber at www.sulprobil.com

Regards,
Bernd