I have a column that is a text . It needs preceeding zero's for identification.
when i copy this data out of a sqy query result and paste it in to excel, it will take out the leading zeros.
I can custom format the column with 0000000000 (ten zeros) and it works fine visibly. when i then take the newly formatted column
of data and paste it to another column, it will revert back and take out the leading zeros. This is paste values.
I can also paste with formatting and that seems to work fine.
My problem is this... when i import that data back into sql, it reverts back to truncating the preceeding zeros.
there are 4 columns that show my process
i can't use the & function or concatenate function to add just one zero because some of the accounts have 2 preceeding zeros...