Like this picture
The init value is ‘10/01/2022’,it means 2022/01/10(yyyy/mm/dd),the cell’s format is General.
After read range and write range ,the value auto change to ‘2022/10/01’,the cell’s format is Date ,the date format is same with my windows(yyyy/mm/dd),the value is wrong.
And the propety ‘PreserveFormat’ is not useful.
Actually,I found use workbook will be ok,but the excel application scope how to ?