Skip to main content
S
simon23189429o8ar
Participant
February 16, 2022
Question

Converting files to Excel turns around day and month

  • February 16, 2022
  • 2 replies
  • 575 views

Is het mogelijk om een word of pdf te converteren naar excel zondat dat hij de bestaande datumnotatie als engels leest? De dag en maanden zijn omgedraaid.

This topic has been closed for replies.

2 replies

try67
Community Expert
try67Community Expert
Community Expert
February 22, 2022

Excel is known to have a lot of issues with dates and strings that can be interpreted as dates.

To avoid this make sure to import all the data as Text.

Meenakshi Negi
Community Manager
Meenakshi NegiCommunity Manager
Community Manager
February 21, 2022

Hi Simon,

 

Thank you for reaching out, and sorry for the delay in response.

 

Would you mind elaborating on your question? 

What do you mean here by "The day and months have been turned around."? 

It would be helpful to share some screenshots for a better understanding. 

 

Thanks,

Meenakshi

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices