If you’re regularly processing multiple Salesforce export files that need decimal formatting corrections, there’s a better approach than bulk replacements that eliminates the problem entirely.
While VBA or PowerQuery can handle batch processing of existing files, switching to direct imports prevents the need for ongoing decimal separator corrections.
Replace your export routine with automated imports using Coefficient
Coefficient eliminates the need for bulk decimal replacements by importing fresh Salesforce data with proper formatting automatically applied. Scheduled imports can replace your regular export routine entirely.
How to make it work
Step 1. Set up direct Salesforce connections.
Install Coefficient in Excel and connect to your Salesforce account. The platform automatically applies your regional decimal formatting preferences during data import.
Step 2. Configure your regular data imports.
Import the same reports or data you typically export from Salesforce. All numeric fields will display with comma decimal separators based on your Excel locale settings.
Step 3. Schedule automatic refreshes.
Set up hourly, daily, or weekly import schedules to replace your manual export routine. Each refresh provides correctly formatted data without requiring bulk processing or decimal corrections.
Stop fixing the same formatting issues
Automated imports with proper formatting eliminate the ongoing need for bulk decimal separator corrections across multiple files. Start using Coefficient to get consistently formatted data on your preferred schedule.