Previous Topic Next Topic

Convert a text number col to text column

Closed
S - 11 May 2012 à 05:18
 Josh - 11 May 2012 à 08:42
Hello,

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

Thanks
S


Related:

1 response

Réponse 1 / 1
Josh
11 May 2012 à 08:42
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.

Similar discussions

How to convert number into text in Excel
boratechandu -
Raj -

9 responses
how to convert Date into text.
rk gupta -
TrowaD -

1 response
how to convert ounces (oz) to milliliter
JPortillo -
vcoolio -

1 response
Ig stories from close friends to public
Darren -
zara -

31 responses
how to change asterisk to letters? forgot recovery email address
baluktot69 -
owilson -

2 responses