Number to text

S

spmenon

Hi,
I got the funtion of spellname for converting number to
word i.e. "125 = one hundred twenty five dollars". But I
need to change the dollar to dirhams since and cents to
fils. When I change it in the programe error
message "variable not foud" is appearing. Please help
 
B

Bernie Deitrick

SPMenon,

You need to include the dirhams in quotes, along the lines of this, if your
function name is "SpellName"

SpellName = SpellName & " Dirhams and " & Remainder & " Fils"

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Number to words 1
convert number to word 1
convert number value to words of numerical value 4
How do I convert numbers to written out text ex. 25 = Twenty Five 2
Convert number in to words 2
How can i change this VBA project According to Indian Numeric 1
formatting a cell 2
Convert numbers to words: Revisited 9

Top