New
#1
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