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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Number to Text for Index/Match 1
add decimal to beginning of number 1
PLEASE HELP!!! I cant convert a cell to text for some reason. 1
Convert text to number automatically 1
convert a number to letter 2
converting numbers to text 2
convert text to values 7
how to add decimal to beginning of imported number 2

Back
Top