Thread: Need to keep text format when retrieving records from database
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Markantesp Markantesp is offline
external usenet poster
  
Posts: 9
Default Need to keep text format when retrieving records from database
I'm importing records from an access database to excel using ADO. When the
records are stored in the excel sheet, the format has changed. How do I keep
it to a text format. For example, record 9900000000000080 has changed from
text to general and now looks like 9.9E+15.
Reply With QuoteReply With Quote