Hi All, I have a problem within a workbook with multiple worksheets. My problem is one of the worksheets switches my date formatting around.
I.E I enter a date in DD/MM/YY but for some reason, it changes to MM/DD/YY. I've tried "Text to columns", I checked the formatting, it's the same as the date
formatting that I've used in other sheets within this workbook. The only conclusion I can come up with is that there must be a code or something doing this.
I.E I enter a date in DD/MM/YY but for some reason, it changes to MM/DD/YY. I've tried "Text to columns", I checked the formatting, it's the same as the date
formatting that I've used in other sheets within this workbook. The only conclusion I can come up with is that there must be a code or something doing this.