Hello,
I am not an excel expert, so I do not know whether the issue I met is related to the below idea:
The issue I met is as below:
1, I formatted a data field in report designer, using “0.00”
2, It is looked nice in screen and when exporting to PDF
However, the data is only displayed in integer format, while it is indeed having 2 decimals value.
on the contrary, the data filed without formatting is looked bad on screen, but it is OK when exporting to excel
Best answer by ChandraM
Hi
I’ve seen this issue too, occasionally, when I export from Generic Inquiries. If you change the format in Excel, it’s fine but by default I’ve also seen that behavior. This becomes an issue with automated exports (like bank feeds). I’m not sure Acumatica can actually do anything about it though since at least in my experience it’s controlled in the Excel application.
I’ve seen this issue too, occasionally, when I export from Generic Inquiries. If you change the format in Excel, it’s fine but by default I’ve also seen that behavior. This becomes an issue with automated exports (like bank feeds). I’m not sure Acumatica can actually do anything about it though since at least in my experience it’s controlled in the Excel application.
Hello, thank you for sharing your experience.
Currently, I am working around it by removing the format control.
It would display 2 decimals in excel.
Hi
Thank you , you solved my problem
below is my update:
format ‘c’ displays great on screen and pdf, ‘c’ stands for currency, so it is shows $ in front of number. But, unfortuantely, it is also shrinked in excel
format ‘#0.00 ’ perfectly showed 2 decimals in everywhere:screen, pdf and excel, Great, Thank you.
+20Thank you
My whole number (Number of Days) field was fine on screen but adding .00 (like 365.00 Days) when exported to excel. This thread helped me! 👍
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
