Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Date Problem - Excel and Quickbooks

12 Oct 2010   #1

Windows 7 Home Premium
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 SpecsSystem Spec
12 Oct 2010   #2

Windows 7 Home Premium

found the answer....

start> "date"

clikc on change date, time..

then look at the second, or third drop down..make sure its mm/dd/yy
My System SpecsSystem Spec

 Date Problem - Excel and Quickbooks

Thread Tools

Similar help and support threads
Thread Forum
Microsoft Excel - The Date Bug
Hey all, Let me just start of by saying, this may be old news but it is still highly relevant in today's market. But there is a large bug in Office's suite all of them in fact (2000 - 2014), concerning the way it handles time / dates. History A brief bit of history for you all, MS decided...
Microsoft Office
Weirdness Excel and Quickbooks
I was trying to lean how to do drop down boxes in Excel and after a while got a practice sheet to do what I wanted it to do. Now when opening the excel sheet, message says "standby while windows configures quickbooks" :p I think I am going to have to delete that spread sheet and start again. ...
Microsoft Office
Excel 2007 Date Factor
I have a spreadsheet of inventory items and the dates are in various formats Europe , USA , and Eastern. Example below. What I need to do is select all the dates and covert into one recognizable formula Month (1) Day (1) Year (****). Let me know how to do this. Thanks! 7/12/00 28/12/00...
Microsoft Office
What is Excel Date Playing At?
I wanted to put a date into a field, but did not want it formatted. In fact it could just represent any 6 digit number; not a date at all. So I put 050811 (today's date the British way DD MM YY) And Excel in its infinite wisdom changed it to: 10/02/2039 I despair! :confused: :eek:
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 18:37.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App