Solved date format in excel 10 will not show uk format dd/mm/yy

March 28, 2016 at 11:06:05
Specs: Windows 10
in spread sheet if I format a cell as English uk date format dd/mm/yy I have to input data as mm/dd/yy and it shows it as uk format but if I input it as uk format it does not. All my older version spread sheets and accounts when opened with excel 10 give me wrong format. I have checked that the transition mormula boxes are unchecked

See More: date format in excel 10 will not show uk format dd/mm/yy

Report •

#1
March 28, 2016 at 11:33:24
✔ Best Answer
It is not an Excel issue.
I believe what you need to do is change the System Date Format,
it is probably set for US and you need to change to UK.

Look here for instructions on changing the System Date:

http://windows.microsoft.com/en-us/...

This is for Win 7, but Win 10 should be similar.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
March 29, 2016 at 06:02:39
Thanks mike that seems to have solved my problem.
Many thanks for your prompt and precise solution.

Report •
Related Solutions


Ask Question