I am just trying to be lazy w/o typing the /'s. I am doing statement ledger and require to input different date of transactions and there are a lot of transactions. Why is it when I type today's date 091006 it comes up 2/28/2149? I set the Format Cells to Category "Date" Type "mdyyyy". What I'm I doing wrong? Is there no way excel can recognized 091006 for 09/10/2006?