I have an insert statement that inserts values from an Excel spreadsheet:
insert into table (number)
values ("$Excel Column(1)$")
I would like to format the data from the spreadsheet to have leading zeros and following zeros (if that is the correct term) so that a value in the spreadsheet that appears as 2.02 would be stored in the number field as 02.020. The data field is specified as nvarchar so that it can hold the numbers and the period. I tried to format the column of cells in Excel but the formatting did not hold on the insert. The format (number,00.000) does not work in the SQL code.
Not sure what to do.