Ranorex opening excel .csv and changing date format from UK format to US format

[_test_king]

I have an excel .csv file in UK date/time format, but when Ranorex opens the .csv file it is switching the UK format (DD/MM/YYYY) to US format (MM/DD/YYYY). Why would Ranorex be doing this and how can I prevent it from doing it? My data/time formatting in Excel is definitely set as UK format.

[Support Team]

Hi all,

The customer contacted us directly.
The problem was the default value of the property "NumberFormat". Simply set this property like in the following example.

Code: Select all

range.EntireColumn.NumberFormat = "DD/MM/YYYY";

I hope that helps.

Sincerely,
Matthias
Support Team