View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daoud Fakhry Daoud Fakhry is offline
external usenet poster
 
Posts: 41
Default Spellnumber - USD/AFa

Hi masters,
I would like to use spellnumber in my worksheet. I want that if I put $200
using currency format in one cell it should give me Two Hundred US Dollars
and No Cents and if I put AFA 200 using currency format it should be able to
return Two Hundred AFA in another cell. I have found the following link to
put in VBA code but some time this is also not working.
http://www.microsoft.com/office/comm...xp=&sloc=en-us

Is there any one who can help me, thanks.

Daoud Fakhry