convert number into letter

[hrist]

hi, is there any formation which can convert from number into letter

for example: I have "100,000 Dollars" in cell A1, and I want to convert that into "100,000 one hundred thousand Dollars" in cell A2

any help would be appreciated. thanks

 

[crook_101]

Hi and Welcome to the Board,

Think the following would be a starting point for you...

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

Cheers,
Ian

 

[hrist]

thank you, it helps a lot, but there's another problem, because i want to keep the number and the letter in one cell, i tried to use "and" formation, but no use

i typed like this: =and(A1, "spellnumber(A1))
thanks

ps: im really bad in excel, so don't mind me xd

 

[Armando Montes]

Something like this
=A1 &" "& spellnumber(A1)