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

• 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

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

• To use space as a thousand separator when converting a numeric field to text in a formula, use the ToText function, and set the third argument with a space like:
    
       ToText(<INSERT YOUR NUMERIC FIELD HERE>,0," ")
    
  Ensure the third argument has a space within the quotes. 
      
    
  Note: By default, when using the function ToText, if you do not specify the thousand separator argument, like:
       
      ToText(<INSERT YOUR NUMERIC FIELD HERE>)
        
  It will take your Microsoft Windows regional default setting for thousand separator, which is usually a comma.

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

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