how to convert numbers to letters

[nasser]

i want to convert numbers to letters in the excel Sheet
I.E: when the number is 1000.00$ it write in another cell
on thousand dollar only

1500.00$ one thousand five hundred dollar only

[Trebor76]

Hi there,

The UDF at http://www.meadinkent.co.uk/xlnumberstext.htm should do the trick.

HTH

Robert

[nasser]

Hi there,

The UDF at http://www.meadinkent.co.uk/xlnumberstext.htm should do the trick.

HTH

Robert

Hi Robert ... thanks for ur help , but i dont know why it gives me this error (value) and open the debug ,, infact i don't know about VBA , so do u have any idea about why it returns that error ?!!!
I attached the file here

[starguy]

Hi Robert ... thanks for ur help , but i dont know why it gives me this error (value) and open the debug ,, infact i don't know about VBA , so do u have any idea about why it returns that error ?!!!
I attached the file here

look here for a complete guide.

http://support.microsoft.com/kb/213360

[nasser]

look here for a complete guide.

http://support.microsoft.com/kb/213360

Dear , this link helped me alot and it's working so well BUT with 2 decimals only
i changed the name of the currenct but I don't know how to change it and make it read the Cents as 3 numbers (1.123) or even to write it back as it is
so i'm trying to do one of those 2 examples :
1- to read 1.123 as One Dollar and 123 cents Only
2- to read 1.123 as one Dollar and one hundred twenty three Cents Only

so is there anyway to make those 2 examples come true ??!!

thanks for ur help

[starguy]

Dear , this link helped me alot and it's working so well BUT with 2 decimals only
i changed the name of the currenct but I don't know how to change it and make it read the Cents as 3 numbers (1.123) or even to write it back as it is
so i'm trying to do one of those 2 examples :
1- to read 1.123 as One Dollar and 123 cents Only
2- to read 1.123 as one Dollar and one hundred twenty three Cents Only

so is there anyway to make those 2 examples come true ??!!

thanks for ur help

for only such small numbers (less than 10) see the attached file.

[nasser]

for only such small numbers (less than 10) see the attached file.

Sorry sir but it's not helpful as i think it should be , the one in the microsoft is good but how to make it read 3 decimals ??
http://support.microsoft.com/kb/213360
how to make it read the decimal digits is some of those ways :-

123.456 to be to be read as
1- One hundred twenty three pound and 456 fils
or
2- One hundred twenty three pound and four hundered fifty six fils

any of those 2 solutions is ok

thanks again and best regards

[nasser]

I Still Looking For How To Do It .. Any Suggestions ??

[nasser]

I wasn't think that i will be that hard to be done ...
it's already working with 12.34 , isn't there any chance to make it read 12.345
just to add one more decimal number
ok no need to read it
is there some way to make it write the numbers after the decimal as it is i mean not in letters ???

[Trebor76]

Hi there,

Try the following formula which assumes your number is in cell A1 (simply change the reference if this is not the case):

=LEFT(spellnumber(A1),SEARCH(" and ",spellnumber(A1))-1)&" "&MID(A1,SEARCH(".",A1)+1,255)

HTH

Robert

[nasser]

Hi there,

Try the following formula which assumes your number is in cell A1 (simply change the reference if this is not the case):

=LEFT(spellnumber(A1),SEARCH(" and ",spellnumber(A1))-1)&" "&MID(A1,SEARCH(".",A1)+1,255)

HTH

Robert

Dear Trebor ..thank you so much it's working so well BUT it's not write the FILS (Cent)
one Dinar & 123 ??

[oldchippy]

May be this link might help,

The formula : “=spellnumber(”1234.5678″,”Dinar”,”Fils”,3)” would therefore result in “One Thousand Two Hundred Thirty Four Dinar and Five Hundred Sixty Seven Fils”

http://www.chalouhis.com/XLBLOG/arch...ned-functions/

[nasser]

May be this link might help,

The formula : “=spellnumber(”1234.5678″,”Dinar”,”Fils”,3)” would therefore result in “One Thousand Two Hundred Thirty Four Dinar and Five Hundred Sixty Seven Fils”

http://www.chalouhis.com/XLBLOG/arch...ned-functions/

Thanks Alot OldChippy i will try it and will reply later

Best Regards

[nasser]

Thanks Alot OldChippy i will try it and will reply later

Best Regards

so sorry for being late , but i'm haveing some hard times after the accedent ,
Dear Old Chippy , i'm sure u made it right but it's not wroking with me , so i visit the sites in the link that u added and i tried it from there but it not accept the formula , it tells that there is something wrong with the formula that i write and not accept it ,,,
any suggetions ??
sorry for late again