Date Problem - Excel and Quickbooks

[jsvlad]

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

 

[jsvlad]

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