Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Changing cell formats from numbers to text

Posted by Joe on July 08, 2001 1:26 PM

I have to change formats in columns of downloaded figures from numbers to text. Using
FORMAT-CELL-TEXT will not actually change the format unless I cursor-select each cell,
press F2 and press Enter. It seems Excel should offer a more immediate way to
mass-change cell formatting.

Is there a command that will change the format in an entire column, or is a macro the
only way to automate this F2-Enter-Down key sequence?

Thanks.

Re: Changing cell formats from numbers to text

Posted by Richard S on July 08, 2001 8:36 PM

When importing the data from an external source, you could nominate the format of the column as text instead of general.

Re: Changing cell formats from numbers to text

Posted by Joe on July 09, 2001 4:27 AM

Thanks for the response, when importing ASCII files I can set the fields to "Text"
and that works fine. It's the .xls files or .xlk files that cause me the problem
when I have to reformat them.

Re: Changing cell formats from numbers to text

Posted by Barrie Davidson on July 09, 2001 12:49 PM

If you select the column of data (one column at a time only), you can then select Data|Text to Columns. This will bring up the "Convert Text to Columns" wizard, which is just like the import wizard box. Specify a text format instead of general and your numbers are now text.

Regards,
Barrie

Re: Changing cell formats from numbers to text PROBLEM SOLVED!

Posted by Joe on July 09, 2001 5:54 PM

Thanks Barrie! That's a great solution, works like a charm.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.