Using a Macro export to excel the format is not applied in Excel

[#1]

Hello Everybody,

Using a macro, I have a clean export to excel(Exporting Pivot table) the problem is the format is not applied even I try to modify manually.

I have attached the sample, when I try to sort the Euro cloumn that is not working.

Any workaround.

Regards

Chriss

[#2]

Hi,

If we format the fields in the chart or table box using Properties -> Number tab or num(field,'000000') then it will apply in the Excel.

Hope this will help.

[#3]

Hi,

Thanks for your reply, I am using AS400 as a data source the above num() expression is working on data type as S(Zoned) but if the data type is P(Packed numeric) its not converting to numeric.

Can anybody advise me...

Regards

Chriss

[#4]

Hi Chris,

Could you please let me know, why there is a "comma separater" in the column Euro?

And also, the column Euro is entered in text format. Can you remove the "comma" & check the same.

Regards,

Anand.

[#5]

Dear Anand,

It' not becaue of comma separater, the macro exports the value in a text format, it's having thousand rows the customer can not sum the euro column, that is the problem.

Regards

Chriss

[#6]

Dear Chriss,

Could you please share the macro which you have written. The Customer cannot sum the euro column, because, the euro column is not in the number format & tried in excel all the possible way to convert the same, but in vein, it is not possible.

So, share the macro let me check on the same & rever u back.

Regards,

Anand

[#7]

Dear Anand,

Thanks for your efforts...

Please find the attached test txt in the orginal post.

Regards

Chriss