SAP Knowledge Base Article - Preview

2114630 - Number Format does not appear properly for integers less than 1000 when exported to CSV Archive

Symptom

In Web Intelligence reports, custom formatting #,##0.00 is applied to values such that

  • 1000 should appear as 1,000.00
  • 500.5 should appear 500.50
  • 500 should appear as 500.00

However, integers less than 1000 do not appear to have the custom formatting applied to them, when CSV archive is opened by Excel (by default).

  • 1000 appears as 1,000.00
  • 500.5 appears as 500.5
  • 500 appears as 500

Read more...

Environment

SAP BusinessObjects Business Intelligence Platform 4.0
SAP BusinessObjects Business Intelligence Platform 4.1

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

format mismatch, export as CSV archive , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

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

Search for additional results

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