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".
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.
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.
