View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Cell formatting changes on export

PRGMRgirl wrote ...

I am having a problem with locking down a format in Excel. When I try
to import a spreadsheet into a SQL environment, it sometimes converts
numbers formatted as text back to a general or number format. This is
causing huge automation problems. Does anyone know a way to lock down
a spreadsheet to a text format?


Explained he

http://www.dicks-blog.com/excel/2004...al_data_m.html

Jamie.

--