In some cells dates format are changed

Closed
aditya - Nov 23, 2016 at 12:57 PM
yg_be Posts 23406 Registration date Sunday June 8, 2008 Status Contributor Last seen December 25, 2024 - Nov 23, 2016 at 02:53 PM
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
Related:

1 response

yg_be Posts 23406 Registration date Sunday June 8, 2008 Status Contributor Last seen December 25, 2024 5
Nov 23, 2016 at 02:53 PM
I suspect this is caused by the regional settings in Windows : does Windosw Explorer show the dates in the format you expect in Excel?
0