W
weckx
Guest
Good day
I get data in xls that i have to upload to our server.
In order that server excepts these files i have to change date format cells to dutch (Belgium).
I do so but still some xls go in error and when i check i find that it didn't correct the date format an put it on "Armenian"
I once was advise the following trick, that after I changed the date format i needed to go to "DATA" => "TEXT to COLUMNS"
2 x next and than finished and the whole column would stay on date format that I did change it. But after one of the office365 updates that even doesn't work anymore
Rgds
Geert Weckx
Continue reading...
I get data in xls that i have to upload to our server.
In order that server excepts these files i have to change date format cells to dutch (Belgium).
I do so but still some xls go in error and when i check i find that it didn't correct the date format an put it on "Armenian"
I once was advise the following trick, that after I changed the date format i needed to go to "DATA" => "TEXT to COLUMNS"
2 x next and than finished and the whole column would stay on date format that I did change it. But after one of the office365 updates that even doesn't work anymore
Rgds
Geert Weckx
Continue reading...