Export MR to Excel - too many decimal places

(0) Share

Report

Posted on by Althea ADS

445

MR set to 2 decimals. Lines are CAL type. Results look fine. Export to Excel and 7-8 decimal places. We copy/paste results to GP as Journal Entry and always shows out of balance. How to format MR to dump 2 decimals to Excel?

*This post is locked for comments

All responses (3)

Answers (0)

Althea ADS 445 on at

Like (0)

Report

RE: Export MR to Excel - too many decimal places

All the rows were using a column that showed $ and another for % (CBR). So they would not format for Excel or we'd lose the % formatting. So what I just tried was to make an additional set of rows that just reference the rows above (CAL type / @100 / format #,###.00) and restrict to column B only. This printed just the description and 2 decimal dollars that did transfer to Excel in the correct format. Now they can scroll down and copy from the bottom for the journal entry (allocations). It still doesn't fix the issue, but still a work around. :-) Thanks!
Suggested answer

ShawnMD 1,456 User Group Leader on at

Like (0)

Report

RE: Export MR to Excel - too many decimal places

Unfortunately, I can't help but to say that I have tried TOO many times to get this to stop... so hopefully someone out there has an answer... but for me, I think we are stuck :-/
Althea ADS 445 on at

Like (0)

Report

RE: Export MR to Excel - too many decimal places

We have tried many formats in MR but all look like they have 2 decimals in MR viewer, but soon as you export to Excel and click on a cell - they are many decimal places. This makes the customer need to format all using the ROUND formula on all (hundreds of) cells. Extra step they must do every day. GP does not like more than 2 decimals in journal entries - says won't post - out of balance.