Convert numbers to text

[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.

 

[Roger Govier]

Hi

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

 

[Gord Dibben]

In a helper column =TEXT(A1,"0000")


Gord Dibben MS Excel MVP

 

[Vik]

I tried that and it did not work - I still got NULLs in SQL Server.

Thanks.

 

[Vik]

Thank you, this works.

In a helper column =TEXT(A1,"0000")


Gord Dibben MS Excel MVP