DATA FORMAT INCORRECT ON EXCEL

Asked By Stan.Bareng 0 points N/A Posted on - 09/23/2011

We use an Excel file for our business to track our daily sales and there is a particular cell on the file where a date needs to be entered. When I right click on the cell and click on Format, and then I go to the Number tab and select Date under category, what's selected there is *3/14/2001. However, when I enter a date such as 8/15/2011, I get an error message "DATA FORMAT INCORRECT! Please ensure your date is formatted MM/DD/YYYY".

The guy who created this Excel file already resigned from our company and it is not easy for us to just simply replace this file so I would really appreciate it if anybody can help me correct this.

Error:

"DATA FORMAT INCORRECT! Please ensure your date is formatted MM/DD/YYYY".

• Status: Open
• Question Views: 1101
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by rmasu

Go To Solution

Best Answer

Best Answer

Answered By rmasu 0 points N/A #127310

DATA FORMAT INCORRECT ON EXCEL

Did you find the present date? You can select the CTRL+ and you will get your present date format. If you simply wish to write the back date on the Excel file, select Row and Column, left click of the mouse and write back date on the Excel formula bar.

You will find your back date in the cell. I have found Format cells. I clicked on it but I didn't find any change or set on the Excel sheet. Should you work with what I have suggested you, please enter on Excel file and make the back date in that file.

About rmasu

Questions
0

Answers
4

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 09/24/2011
• Question Category: MS Excel

Answered By Anthew Staw 0 points N/A #127311

DATA FORMAT INCORRECT ON EXCEL

 

I have read your post and I think I have the solution for that. I think the OS and the MS office of your computer is outdated. I have read an article and found out that problem is actually caused by a misinterpretation between the locale date and the date format. What you need to do is update your operating system (OS) and your MS OFFICE. Hope this helps.

About Anthew Staw

Questions
3

Answers
34

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/03/2012
• Question Category: MS Excel