SAP Knowledge Base Article - Preview

1209116 - Formatting a number field to have spaces for 'thousands' separators in Crystal Reports

Symptom

  • How to use a space as a thousand separator?
  • How to change the thousand separator from a comma to a space in a formula?
  • How do I format a number field to incorporate spaces, rather than commas, for the 'thousands' separators, using a formula in Crystal Reports?
       
    For example: How to changing the appearance of a number like:
         
          7,894,562,235
       
    To look like:                                                         
         
          7 894 562 235


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

SPACES COMMAS REPLACE THOUSAND SEPARATOR NUMBER FIELD Seagate Crystal Reports Formatting Numbers Separating Thousands Commas With a Space , , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

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.