alphabetical numbers format

[ELBA]

hi all
i de like to know how to convert numbers into alfabetical format

exemple:
cell a1 contains : 152
i need cell a2 to be automatically : one hundred fifty two

and thanks for every help

[dominicb]

Good evening ELBA

Download and install my add-in via the link below. Once installed go to Ultimate > Formulae > Add Function.
From the listbox choose SpellNumber and click Add Function. This will add a small macro to your workbook. Then use this formula :

=SpellNumber(A1)

There are several optional switches for dealing with currencies and formatting etc - these are detailed in the help file (Ultimate > Help).

HTH

DominicB

[ELBA]

thanks a lot for u re fast reply
i ll be trying it right now

[ELBA]

it worked fine but it show currency with it which i need to change it or remove it

152 :one hundred and fifty two pounds and no pence

i only need the number so how can i change the formula to remove "pounds and no pence"

or to change it to dollars if no way to remove it

[dominicb]

Hi ELBA

Use :

=SpellNumber(A1,"")
for no currency, or

=SpellNumber(A1,"USD")
for US Dollars.

HTH

DominicB

[ELBA]

bothering u too much my friend :D

i still have one quest

how to disable the fraction part (decimals)

it s giving me and no cents in case of usd
and ""and no"" in case of no currency

and really big thanks for your help