Convert a text number col to text column

S - May 11, 2012 at 05:18 AM
 Josh - May 11, 2012 at 08:42 AM

Pls could you help me with this.
I have a column in number format. this column contains 'NULL' (literally 'NULL' populated) in some of the cells.
I need to convert this number col to text col, as this excel sheet will be passed thru another piece of software for processing. This piece of software fails to run, due to 'NULL' populated cells in the column formatted as Numbers

How do I convert columns formatted as Number into Text


1 reply

Not sure if this is what you are looking for, but you can select that column, right click and Format Cells, select Text in the Number tab, then click OK. Now that column is in Text format.
Good luck.