In some cells dates format are changed [Closed]

Report
-
Posts
14010
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
January 23, 2021
-
Hello,
the prblem is that when i upgraded to office 10 then formate of dates are changed in some cells of the worksheets and whn i changed the formate thn some cells are showing 19/1/16 and some are showing 1/19/16 pls help me in this i m in big problem

1 reply

Posts
14010
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
January 23, 2021
4
I suspect this is caused by the regional settings in Windows : does Windosw Explorer show the dates in the format you expect in Excel?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!