L
Louise
What is the quick way to convert a number in a cell to
text?? I can't remember. I'm working with Office 97.
Thank you.
text?? I can't remember. I'm working with Office 97.
Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Otto Moehrbach
Louise
Put an asterisk in front of the number. HTH Otto
Put an asterisk in front of the number. HTH Otto
D
Dave R.
I think you mean convert a number value to an english word?
there is an add in called morefunc.dll here;
http://longre.free.fr/english/
There is a formula called NUMTEXT that converts, for example, 45 into
"forty-five".
there is an add in called morefunc.dll here;
http://longre.free.fr/english/
There is a formula called NUMTEXT that converts, for example, 45 into
"forty-five".
M
Mark Graesser
If you mean the number as text, tehn the text function
=Text(A1,number format
Good Luck
Mark Graesse
[email protected]
----- Louise wrote: ----
What is the quick way to convert a number in a cell to
text?? I can't remember. I'm working with Office 97
Thank you
=Text(A1,number format
Good Luck
Mark Graesse
[email protected]
----- Louise wrote: ----
What is the quick way to convert a number in a cell to
text?? I can't remember. I'm working with Office 97
Thank you
O
Otto Moehrbach
Oops. I meant an apostrophe. Old age is killing me. Otto