Convert numbers to text

V

Vik

I have a column of numbers that I need to import into a SQL Server. I need
to keep the numbers with the leading zeros (e.g. 0004 instead of 4). If I
enter '0004 into a cell and then import the data into the SQL Server I get
NULL for that cell.

Is it possible to convert the whole column of numbers into text? Is there
another way to fix this problem?

Thanks.
 
R

Roger Govier

Hi

Pre format the column as Text and enter 0004 or
Custom format the column
Format>Cells>Number>Custom>0000
 
Top