| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| REPLACE command drops leading zeros | Excel Discussion (Misc queries) | |||
| csv format drops ending zeros | Excel Discussion (Misc queries) | |||
| EXCEL DROPS OFF ALL ZEROS PRECEEDING A NUMBER | Excel Discussion (Misc queries) | |||
| line graph drops when zeros | Charts and Charting in Excel | |||
| csv file drops zeros at beginning of a set of Numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
