Solved

Exporting data gets wierd format

  • 22 May 2023
  • 2 replies
  • 68 views

Userlevel 2
Badge +7
  • Do Gooder (Customer)
  • 21 replies

Hi!

One user is tryying to export data in Excel from IFS but gets wierd format.

Not able to handle the data in this format.

 

Me on other hand, gets the data in correct format:

 


What can be the problem?

icon

Best answer by MMcK 22 May 2023, 12:07

View original

2 replies

Userlevel 2
Badge +10

Hi

It’s difficult to tell without more information and it doesn’t look like your screenshots are showing the same data, but is it possible that there’s a mismatch in either date or number formatting due to different regional settings?

For example, is Excel expecting a period (dot) as the decimal indicator rather than a comma?

 

Userlevel 2
Badge +7

Hi! @MMcK yes, the problem were regional settings on the local computer.
Thanks.

Reply