[dba-SQLServer] Excel zip imports

I imported a zip database into SQL Server from Excel.  The data out in Excel
is numeric (float according to the imported table).  As a result the leading
zeros were stripped off.  Two questions, is it possible to format fields
such as this with leading zeros as you import them (and if so how), and now
that I have it in the database, how can I get the leading zeros back.  I
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com