How can I export numbers from excel to sql server as text without truncation of leading zeros

Assuming your value is in A1, try this:
=Text(A1,"0000.0000")

I have hundreds of rows and would like to avoid editing each one ...

import the column as a varchar/text datatype instead of numeric column

also, once in sql server you can use the replicate function to re-pad your zeros if applicable

I tried importing to Sql Server as nvarchar but it still showed the Excel spread sheet source column as containing floating point numbers float and truncated leading zeros.  I can't automatically replicate as I do not always have the same number of leading zeros.  I can mot change the source

As bromee suggested, if you do that in a column next to your A1, you can just double click the bottom right corner of the cell, it'll be extended down to your last row automatically (assuming excel 2003) Shouldn't take too long.

Creating a duplicate column as Tyug suggests doesn't solve my problem.  All that accomplishes is copying the value in Excel to a new Excel column.  I need to import it (with leading zeros) to sql server as a text field with any leading zeros.

I did try selecting the entire column and changing the format to text.  However, it still came acreoss as numbers with the leading zeros stripped.

The original Excel table came in the older .xls form with protected macros.  When I saved it without macros as a .xlsx file and then selected the entire column and saved it as text as suggested by dbaduck I was able to properly import it.  So, I am accepting that solution.

Thanks to all.

Thanks again!