Previous Topic Next Topic

In some cells dates format are changed

Closed
aditya - Nov 23, 2016 at 12:57 PM
yg_be Posts 24281 Status Contributor - 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

1 response

Answer 1 / 1
yg_be Posts 24281 Status Contributor 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?

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Anyone's dm order all weird ?
Tillyleon111 -
toogleeful -

2 responses