File Date Format Changes When File is Sent to a Different System

Question

#system-1#

file1.xls

11/04/2018
12/04/2018
13/04/2018
14/04/2018
15/04/2018

#Sytem-2#

file1.xls

04-11-2018
04-12-2018
04-13-2018
14/04/2018
15/04/2018

I tried to change the format to text.

Answer 1

The date format takes the values from Region and Language in Windows (ignore the orange squares):

Switching between systems, you have two options:

• With formula:

  =TEXT(A1, "mm/dd/yyyy")

• With apostroph:

  Add ' in front of the date, to convert it to text.