Happy Business Starts Here

How do I change the number format in reports and exports

Support SME

How do I change the number format in reports and exports

When exporting reports to Excel, numbers appears with a space as thousand separator i.e. "1 000,00", and Excel is not able to recognize it as a number.

 

I have tried with both Norwegian and US number format settings in Excel, but Excel can still recognize the imported data. I have also tried the substitute formula to remove spaces, but it does not work.

My only way around is to manually punch all the numbers in a new column, but this is way too time consuming on big reports.

 

Is there a setting in Zuora to tell it how to export numbers in the Reports screen, or any other workaround in Zuora and/or Excel?



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

2 REPLIES
Support SME

Re: How do I change the number format in reports and exports

Please do the following to change your Locale of your profile:

 

Profile -> Manage your Profile -> Change Locale to something else, such as English (United States)

 

 



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Newly Enrolled

Re: How do I change the number format in reports and exports

Hope, this will help you to reduce your time.

 

1) by selecting fileds / column where the amount are not readable as numbers - 

replace all spaces in between numbers by delete space

and 

then replace all "," with delete space

2) it will convert to number format 

else 

after doing this select the specific column and "text to data" by simply clicking next next next finish