Convert numbers to text

  • Thread starter Thread starter Vik
  • Start date Start date
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.
 
Hi

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