title: How to remove "no cents" when spelling out cents less dollar figures in excel?
body: <p>I am being able to spell out dollar number in excel perfectly. But what I dont want is when it spells out "no cents". So let say if I wanted to spell out 24030. It would say Twenty Four Thousand Thirty Dollars and no cents. I want excel only to spell out the cents value only when it is present.</p>
  
  <p>Currently I am spelling out the dollar value using module from the microsoft support website and here is the link <a href="http://support.microsoft.com/KB/213360" rel="nofollow">http://support.microsoft.com/KB/213360</a></p>
  
  <p>I would really appreciate if someone could help me in this. Thanks a bunch in advance.</p>
  
  <p>I apologies in advance if this question has already been asked but on my defense I was unable to find the right answer for it. So hopefully some one can help me on this issue.</p>