drops leading zeros on SAP download

J

JL

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to stop Excel from automatically truncating leading zeros 2
Need 7 digit number with differnt number of leading zeros 10
How do I stop Excel from dropping leading zeros? 2
REPLACE command drops leading zeros 4
Add Leading Zeros 4
Time format hh:nn drops leading zero 0
Stop automatically removing leading zeros? 2
Keeping Leading Zeros; How Please ? 2

Top