How can get a number to be shown as a text???
M Marcelo Jun 6, 2006 #2 hi, what you would like to do? 1 = one or just 1 but as a text? regards "retrospect" escreveu:
G Guest Jun 6, 2006 #3 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.
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.
B bplumhoff Jun 7, 2006 #5 Hello, I suggest to take my UDF spellnumber: http://www.sulprobil.com/html/spellnumber.html You can omit the suffix "Dollar...". HTH, Bernd
Hello, I suggest to take my UDF spellnumber: http://www.sulprobil.com/html/spellnumber.html You can omit the suffix "Dollar...". HTH, Bernd