Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

RW99 · 08-04-2015, 10:44 AM

I see through search we have plenty of individual question threads and bumping one of them didn't seem like the best option. So I've created this general question thread for Excel noobs like myself.

My issue is date formatting. I have a .xls file at work, on Excel 2010, Windows 7. When I bring it home to my Excel 2013, Windows 7, I can not get date formatting to work. On the spreadsheet dates are entered as 08/04/2015. When I enter new dates at home in Excel 2013, it keeps changing to 8/4/2015.

I'm guessing the issue is in my regional settings for Windows 7? I've gone through all of those, making sure I selected mm/dd/yyyy, changing from US to Canada, etc. But for the life of me I still cant get Excel to recognize those zeros. Any ideas? Searching online has been a headache as well, just cant find my specific issue anywhere.

08-04-2015, 10:44 AM	#1
RW99 First Line Centre Join Date: Oct 2005 Location: 103 104END 106 109 111 117 122 202 203 207 208 216 217 219 221 222 224 225 313 317 HC G Exp:	Excel questions thread I see through search we have plenty of individual question threads and bumping one of them didn't seem like the best option. So I've created this general question thread for Excel noobs like myself. My issue is date formatting. I have a .xls file at work, on Excel 2010, Windows 7. When I bring it home to my Excel 2013, Windows 7, I can not get date formatting to work. On the spreadsheet dates are entered as 08/04/2015. When I enter new dates at home in Excel 2013, it keeps changing to 8/4/2015. I'm guessing the issue is in my regional settings for Windows 7? I've gone through all of those, making sure I selected mm/dd/yyyy, changing from US to Canada, etc. But for the life of me I still cant get Excel to recognize those zeros. Any ideas? Searching online has been a headache as well, just cant find my specific issue anywhere.