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

Hi

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!
Jason

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
Reply

 Date Problem - Excel and Quickbooks




Thread Tools



Similar help and support threads for2: Date Problem - Excel and Quickbooks
Thread Forum
Excel 2007 Date Factor Microsoft Office
Separating date and time in Excel Office 2007 Microsoft Office
Solved Excel 2010 question: Date 00-00-0000 (08-03-2012)(dd-mm-yyyy) Microsoft Office
Solved 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

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 12:38 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33