SAP Knowledge Base Article - Preview

1916227 - Excel cell display formatting affects how numeric values are imported - Data Services 4.x


  • Numeric values are cut off
  • Numeric values are truncated
  • Excel cell display formatting affects the data imported
  • Full numeric values are not imported from Excel source
  • Actual cell values contained in spreadsheet are not imported
  • Display format in Excel is set to mask the numbers after the decimal
  • Spreadsheet is imported to Excel workbook format with datatype of DOUBLE
  • Numbers after the decimal point are not read in by the Excel workbook source



SAP Data Services 4.x


SAP Data Services all versions


BODS, DSXI , KBA , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.