When a user extracts a CSV file from the CRM report, some fields appear as: #NAME? when opening the CSV file with Microsoft Excel.
This is a Microsoft Excel behavior. If any text starts with -, +, = or any other symbol, it considers it as a formula.
There are two ways to resolve this issue:
- Select the .xls format when exporting a report.
- Open the CSV file with Text Editor and to see the correct value.