Excel Save to PDF ignoring currency format

Help Activities
, ,
1

I have a weird issue happening in production, my workflow is completely ignoring the number formatting when it exports the workbook as pdf.

So, the Excel file is saved correctly but the PDF has the incorrect currency formatting.

Here are some facts

  • The PDF is exported after the file is saved
  • I’m using Office 365 classic
  • It was originally within the same process scope before started failing
  • I have tried adding delays, separating the scopes, killing the excel process, even when excel is visible the number format reads fine on Excel but is incorrect on the PDF
  • It runs well on DEV
  • the only variable is we changed the user on the license of the PROD server, so I’m guessing it should be related to localization. However it looks the same as my dev environment.

Any suggestions?

1 Like
Forum Engagement Daily Reports
2

Hi @Botzilla

Can you try to run one macro to check data is reflecting correct or not in test environment

Range(“A1:A100”).NumberFormat = “₹#,##0.00” ’ or whatever format you have

Try this

3

Update to this, I updated windows regional settings on the server. Once updated the pdf generated as intended.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.