alphabetical numbers format

**ELBA** · 05-22-2007, 05:09 PM

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** · 05-22-2007, 05:16 PM

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** · 05-22-2007, 05:24 PM

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

**ELBA** · 05-22-2007, 05:49 PM

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** · 05-22-2007, 05:57 PM

Hi ELBA

Use :

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

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

HTH

DominicB

**ELBA** · 05-22-2007, 06:11 PM

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

**dominicb** · 05-22-2007, 06:19 PM

Hi ELBA

No-one has ever asked for no currency before, so no-one has reported this quirk. I will fix it in the next release, however, you can use this as a workaround :

=SUBSTITUTE(SpellNumber(A1,""),"and No","")

Note : it is case sensitve, so the capital N in No is important...
It's 11:15 at night where I live now, so I'm going to bed. If you have any more problems, post back and I'll try and help out tomorrow.

Good night!

HTH

DominicB