cancel
Showing results for 
Search instead for 
Did you mean: 
liz-tilbrook
Level 1

When exporting a report 'Sales by Product/Service, the data appears in excel as comma delimited. How to reformat this so that report data can be changed to number format

 
1 Comment 1
SarahannC
Moderator

When exporting a report 'Sales by Product/Service, the data appears in excel as comma delimited. How to reformat this so that report data can be changed to number format

Hi there, liz-tilbrook.

 

You'll have to locate where the report is and save it again as an Excel Workbook. It will create another file. Please note that this is only a temporary solution.

 

For the permanent fix, you can check the browser settings with an IT expert.

 

I'll be around if you have further questions.