Skip to main content
Solved

Exporting data gets wierd format

  • May 22, 2023
  • 2 replies
  • 111 views

Forum|alt.badge.img+7
  • Do Gooder (Customer)
  • 22 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?

Best answer by MMcK

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?

 

2 replies

Forum|alt.badge.img+10
  • Hero (Customer)
  • 77 replies
  • Answer
  • May 22, 2023

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?

 


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Customer)
  • 22 replies
  • May 22, 2023

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