I have a SQL that when runs pulls information where one of the fields start with a zero or multiple zeros. When i export to excel it is auto deleting the zeros. I already went in and set column A to be put as text when i open ANY excel document. Problem being, is that when i export to excel it doesn't go to that excel book. It goes to a SQL default excel spreadsheet. Is there somewhere that i can redirect it or program it to go to have column A be text?
December 13th, 2007, 10:08 PM
That probably has to do with the formatting of the cell try some different settings... Excel may see 0 as well what it is, nothing and omit it if that makes sense.