is it possible to change the Datatype in a excel file from the Float to varchar

Hi,

I have a excel file and i am trying to import zip codes to the database... but the some of the zip codes start with 06902 but the excel file treats them as float but i want to treat them as varchar...

How can i do it.

Regards

Karen

Try changing the column in Excel to a Text Column. To do that, select the column by clicking on the column heading, then format the cells and select text.|||

Thanks for ur answer,

I did it... But when i transfer the data to sql and the column which were converted to Text are NULL in Sql server...

so what should i do... and when i create a table it takes it RtnAddrZip as Float in excel

REgards

Karen