Cell formatting changes on export
 

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 FORMATCELLSTEXT 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

--
Message posted from http://www.ExcelForum.com

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.

--