Send to Excel - Data Format Issue

[#1]

Hi,

I have pivot table with some integer value, percentage (%) value and date. When i press the "Send to Excel", all the values are exported as number. Herewith i have attached the images for your reference.

Pivot Table

Exported Data

Regards

Rajesh

[#2 · Accepted solution]

Hi Rajesh,

This may be the problem, when you try to format the expression with two or more formatings.

One solution would be for this is enclosing the expression with text() function.

 text(if(Product = 'A',num(Sum (Sales),'##.00%'),num(Sum (Sales),'##.00')))

Check the attachment as well.

Hope this may help you.

-Peterson

[#3]

Thanks Kelvin.