ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2002 - Date format keeps changing (https://www.excelbanter.com/excel-discussion-misc-queries/69882-excel-2002-date-format-keeps-changing.html)

B. Levien

Excel 2002 - Date format keeps changing
 
I have a user whose date format keeps changing.

If she puts 6/3/2006 (June 3, 2006) in a cell, it changes to 3/6/2006 ...
this does not appear to happen in all cells. She has one column where the
first few are okay, but then the cell format keeps changing.

I note that the "location" in cell formatting is set to Armenian (how do I
change to Canada)?

Thank you.


All times are GMT +1. The time now is 09:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com