Skip to main content
Solved

Formatted Decimal Data issue when exporting from Report to Excel


Forum|alt.badge.img+5
  • Captain II
  • 398 replies

Hello,

       I am not an excel expert, so I do not know whether the issue I met is related to the below idea:

https://community.acumatica.com/ideas/fix-formatting-of-reports-exported-to-excel-to-faciliate-analysis-1145

 

        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 @ray20 Please try setting the Format to ‘c’ (Small case), as shown in the below screenshot. Also, try setting the Format #0.00 

 

View original
Did this topic help you find an answer to your question?

6 replies

arlinewelty93
Jr Varsity III
Forum|alt.badge.img

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.


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • June 23, 2021
arlinewelty93 wrote:

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.

@arlinewelty93 
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.


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • Answer
  • July 1, 2021

Hi @ray20 Please try setting the Format to ‘c’ (Small case), as shown in the below screenshot. Also, try setting the Format #0.00 

 


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 398 replies
  • July 2, 2021

@ChandrasekharM 
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.


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • July 2, 2021

Hi @ray20 Glad to know that the solution resolved the issue.

Thanks

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • August 2, 2023

Thank you @ray20 and @ChandrasekharM !

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings