I have a vb program that takes a skeleton xls file with a few rows of
headers and an sql command to obtaiin data, and then populates the
spreadsheet. The number of rows and columns varies as does the type of
data in each row.
I have a problem where 12 digit numbers that start out as varchar in
the database, end up in scientific notation in the spreadsheet. From
the help, I see where this is the default for 12 digit numbers or
higher.
How can disable this so they display as regular character data? We
send these spreadsheets to clients so the appearance is important. We
recently migrated from 97 to 2003 - this appears to be a new feature
in 2003 version.
Thanks for any assistance...charlie

Set the format of the columns to Number rather than General. Although this
may cause problems if you they aren't integers. Alternatively, if these are
product/serial numbers that can have leading zeros you might want Text
formatting instead.

Cheers, Pete

" wrote:

I have a vb program that takes a skeleton xls file with a few rows of
headers and an sql command to obtaiin data, and then populates the
spreadsheet. The number of rows and columns varies as does the type of
data in each row.
I have a problem where 12 digit numbers that start out as varchar in
the database, end up in scientific notation in the spreadsheet. From
the help, I see where this is the default for 12 digit numbers or
higher.
How can disable this so they display as regular character data? We
send these spreadsheets to clients so the appearance is important. We
recently migrated from 97 to 2003 - this appears to be a new feature
in 2003 version.
Thanks for any assistance...charlie