View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] cs_hart@yahoo.com is offline
external usenet poster
 
Posts: 2
Default prevent schientific notation

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