Firstly: the correct way to store this information in a spreadsheet would be to format the column as Text. That would prevent anything like "Precision as shown" from affecting the data. ID numbers aren't really numbers, since it is meaningless to do mathematical operations on them.
Secondly: I had a similar problem recently in Excel, where we have a sheet with VBA code that opens a list of other spreadsheets and writes out the data in the other sheets as a CSV file. It was writing the data as displayed, so 123456789 came out as "1E+09". Fixed it by adding a "Columns.AutoFit" method call on the sheet object. Phil Hibbs. -- Don't you just hate self-referential sigs? --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
