|12 Oct 2010||#1|
| || |
Date Problem - Excel and Quickbooks
For some reason, both my excel and my quickbooks will only output dates as dd-mm-yy
I know that in excel, i can go to format cell>custom> mm/dd/yy.
But, if i enter into the next cell, 1/30/2010 the computer does NOT recognize it as a date.. it sees it as 1st day of the 30th month in year 2010.
I just installed Quickbooks, and I copied an old file, went to the check register, and all the dates came out as 30-1-2010. This is VERY strange to me .. it seems there's something WRONG with windows.. it keeps putting my dates for my programs as mm/dd/yy which I do not want.
I am in America and I want the American format - mm/dd/yy.
I do have a "hebrew keyboard" installed on my computer. I hope that does not corrupt things.
Please let me know how to solve this!
|My System Specs|
|Similar help and support threads for2: Date Problem - Excel and Quickbooks|
|Excel 2007 Date Factor||Microsoft Office|
|Separating date and time in Excel Office 2007||Microsoft Office|
|Excel 2010 question: Date 00-00-0000 (08-03-2012)(dd-mm-yyyy)||Microsoft Office|
|What is Excel Date Playing At?||Microsoft Office|
|Excel 2007: a question about date and time manipulation||Software|
|Date questions...Excel 2007||Microsoft Office|
|Excel and MS-Money 2005 date and time format display issue||Microsoft Office|