function help

[retrospect]

How can get a number to be shown as a text???

 

[Guest]

hi, what you would like to do?

1 = one or just 1 but as a text?

regards



"retrospect" escreveu:

 

[Guest]

Hi

You can input a number preceded by a ' to make Excel treat it as text or
you can format the cell as text before you enter a number.

Hope this helps.
Andy.

 

[retrospect]

exaple: 154 = one hundred and fifty fou

 

[bplumhoff]

Hello,

I suggest to take my UDF spellnumber:
http://www.sulprobil.com/html/spellnumber.html

You can omit the suffix "Dollar...".

HTH,
Bernd