Unanswered

OneDrive convert file action - Excel to PDF with wrong formatting for dates and numbers

(0) Share

Report

Posted on by MarMos

I use OneDrive convert file to convert an Excel file to PDF. The conversion itself works great, but numbers and dates are saved with wrong formats in the PDF. I tried to change the regional and language settings for the user, but nothing helps.

Excel Original	Excel converted to PDF
Excel original	Excel converted to PDF

Has somenone an idea, how to solve this issue.

Thanks in advance!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @MarMos

What format is that column in Excel? Since it has dates and numbers at the same time?

Was this reply helpful? Yes No
MarMos 16 on at

Like (0)

Report
Copy link

Link copied!

It doesn't matter if the cell or the whole column is formated as date or number - it will allways be result that the values are formated in US format.

Was this reply helpful? Yes No