Cell formatting changes on export

[PRGMRgirl]

Good morning!

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

BTW: I have tried the usual FORMAT>CELLS>TEXT and though it changes th
format, when I try to export it, the cells sometimes revert to genera
or number format.

I have also tried locking the cells, etc, to no avail.

Thanks in advance for your help!

prgmrgir

 

[Jamie Collins]

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 here:

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

Jamie.

--