function help

[retrospect]

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

[Marcelo]

hi, what you would like to do?

1 = one or just 1 but as a text?

regards



"retrospect" escreveu:

>
> How can get a number to be shown as a text???
>
>
> --
> retrospect
> ------------------------------------------------------------------------
> retrospect's Profile: http://www.excelforum.com/member.php...o&userid=34173
> View this thread: http://www.excelforum.com/showthread...hreadid=548911
>
>

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" <[email protected]> wrote
in message news:[email protected]...
>
> How can get a number to be shown as a text???
>
>
> --
> retrospect
> ------------------------------------------------------------------------
> retrospect's Profile:
> http://www.excelforum.com/member.php...o&userid=34173
> View this thread: http://www.excelforum.com/showthread...hreadid=548911
>

[retrospect]

exaple: 154 = one hundred and fifty four

[[email protected]]

Hello,

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

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

HTH,
Bernd