Text add-in

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

Good morning all

I have just installed the add-in morefunc.dll so I can
convert a number into text format, however, now it's
installed, I don't know how to use it!!!!

Can anybody shed any light???

Thanks.

Louise.
 
The extra functions can be used in the same way as other Excel functions.
The one for number-to-text is called NBTEXT.

It's full syntax is:
=NBTEXT(Number,Language,Type,Unit1 (sing),Unit1 (plur),Unit2 (sing),Unit2
(plur),Style,Gender1, Gender2)

You can see full details in the morefunc help file.
Selct Insert>function (or click fx button).
Select the Morefunc category and scroll to NBTEXT.
Click on "help on this function" for a comprehensive guide to the function.

hth
Tony
 
I have NBTEXT function for the first time and can't get
it to work. When I have entered the formula and press
Enter, the cell goes completely blank??? All I want to
do is convert a number into text format. I have
downloaded the add-in function but this crashes my laptop
every time I use it.

Am I doing something wrong??

Thanks, Louise.
 
Back
Top