Search
Welcome to M-Files Empower – our new support experience. We'd love to hear what you think!Give feedback
Home/Support and troubleshooting/Troubleshooting/Error resolution

Using '.' and ',' as decimal separators in Excel may lead wrong values in PDF Processor conversion

Last updated on 16 June 2025

Admin
PDF Processor (Compliance Kit)

Overview

The user may observe that after converting Excel file to PDF via the Compliance Kit's PDF Processor, some numerical values have either incorrect decimal numbers or show the error "#VALUE!".

However, the Original Excel sheet shows the correct values.

Solution

This issue is likely caused by an Excel sheet containing calculations for these cells, in which both '.' (dot) and ',' (comma) are used as decimal separators in shells used in calculation formulas.

Make sure that the Excel sheet consistently includes either '.' or ',' as decimal separators in shells used in the calculation formula but not both of them mixed.

In Excel, using both '.' and ',' as decimal separators in different cells can cause errors in calculations because Excel interprets these characters based on regional settings and cell formatting.

Still need help?

On this page