convert column from numbers to text

T

Tim

I have a column of about 600 numbers I want to convert to text (with the
little green triangle)...I "think" I have done it...but in my new column I
have to open each cell and then close it before the triangle appears ?
Is this ok...or should the triangle appear automatically...and if so...how
to do this?

Also...a short example of how to convert a column form numbers to text would
be appreciated...in case I have to start over ?
Excel 2003

Thanks, Tim R
 
M

Max

As-is, with source numbers running in A1 down,
Put in B1: =A1&""
Copy down, then copy n paste special as values to overwrite col A. Clear col
B.

If you need it transformed with leading zeros added
Put instead in B1, something like:
=TEXT(A1,"0000")
Copy down, then copy n paste special as values to overwrite col A. Clear col
B. Adapt the number of zeros in: "0000" to suit
 
R

Rick Rothstein \(MVP - VB\)

I have a column of about 600 numbers I want to convert to text (with the
little green triangle)...I "think" I have done it...but in my new column I
have to open each cell and then close it before the triangle appears ?
Is this ok...or should the triangle appear automatically...and if so...how
to do this?

Also...a short example of how to convert a column form numbers to text
would be appreciated...in case I have to start over ?
Excel 2003

Select the entire column, click Data/Text To Columns on Excel's menu bar;
click OK twice on the dialog box that appears in order to get to step 3 and
select the Text option button from the "Column data format" section;
finally, click the Finish button. Your numbers should now be text (and the
green triangles should appear).

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top