Date formatting error

  • Thread starter Thread starter Cindyt
  • Start date Start date
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

Problem with Date format 2
Conditional formatting in Excel 2010 2
Conditional formatting dates 2
Remove date format? 3
Cell Format Defaults to a Formula 2
Date format in cell 3
Autofit Unmerged Cells (XP & Excel 2003) 4
Formatting Dates from 1700 & 1800s 1

Back
Top