How to maintain formatting when importing Excel spreadsheet?

F

Fred

Is it possible to maintain formatting information when importing
data into a table from an Excel spreadsheet, with formatted
numbers? For example, if a column in the spreadsheet contains:

00123.76
00456.91
01654.00

When I import them, they drop the leading and trailing zeros,
and the above numbers are imported as:

123.76
456.91
1654


-Thanks
 
Top