function help
 

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

function help
 

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

function help
 

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" wrote
in message ...

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

function help
 

exaple: 154 = one hundred and fifty four


--
retrospect
------------------------------------------------------------------------
retrospect's Profile: http://www.excelforum.com/member.php...o&userid=34173
View this thread: http://www.excelforum.com/showthread...hreadid=548911

function help
 

Hello,

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

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

HTH,
Bernd