drops leading zeros on SAP download
 

Downloading from SAP to Excel 2003, only dollars were treated as numbers,
other fields were Text. Excel 2007, all fields that appear to be numbers are
treated as numbers and any leading zeros are dropped. Is there a solution
other than to customize every column/field.