Date formatting error

C

Cindyt

I have a spread sheet that has a column for dates - formatted for dates-

In some cells, when I enter 8/1/09 it turns it into a formula and gives me
1/0/1900. I've tried deleting, erasing, everything! Please help.

thanks! ckt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofit Unmerged Cells (XP & Excel 2003) 4
Formatting Dates from 1700 & 1800s 1
Problem with Date format 2
Conditional formatting in Excel 2010 2
Excel Dragging countif formula with changing criteria 3
Using SUMIFS with date range 4
Excel Average dates help 0
Date formats 1

Top