Export Data Store Entity to Excel -Negative number quoted.

Question

I have a column in database view of type decimal (20,2) and it can take both negative and positive number. Now on downloading excel doc via out-of-the box feature (Export Data Store Entity to Excel), all the number are being quoted inside single quotes but not the positive ones. 
 Any way to get rid of this?

Dhananjay Kumar · Accepted Answer

Just adding a solution here. 
 If we use fixed function, then excel shows apostrophe symbol on digits more than 9,2 for negative number. 
 If we use regexreplaceall() then it works, it does not show apostrophe symbol digits more than 9,2 for negative number. 
 
 However, in both the cases, selection sum is not happening.

Export Data Store Entity to Excel -Negative number quoted.

Top Replies