Converting numbers into text

[mathguy]

Hi,

I am trying to convert numbers into text. I have tried formatting bu
it does not work. I am importing these excel data into SAS and SAS doe
not recognize the formatting. I think I need a quick way to add a
apostrophe in front of all my numbers, how?

Thank

 

[mathguy]

I did try formatting the cells, but this does not really change th
number into text....

I want there to be an error in the cell, that is, I want excel to tel
me that the numbers are stored as text

 

[A.W.J. Ales]

Mathguy,

If your numbers are in a fixed format (for instance integer), you could try
this :
Suppose your numbers are in column A1:A5. In B1:B5 insert the formula :
Text(A1 ; "0") to Text(A5;"0"). Then copy column B and
Paste/Special/Value.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[mathguy]

using TEXT() formula works, but is there a faster way of applying thi
across multiplt worksheets/workbooks

 

[Maurice]

Try this freeware program at http://www.asap-utilities.com/

when installed use Numbers . Convert Numbers to text

Great little program, and i have no affiliation with the autho

 

[mathguy]

Thanks so much, the ASAP add-in worked great

 

[Mike]

A trick I used to do this is to use the concatenate
formula. In cell B1, type the following formula:

=concatenate(A1)

There might be another way, but this worked for me ...