Microsoft Office

Date format issues in MS Office Excel

Issue with Excel Date format: experiencing issues in Excel such as trying to use the MM/dd/yyyy format and run into an issue of the cell reverting back to a 1 digit month, even after using custom formating and copying/pasting to a new worksheet the date reverts back to the unwanted format.

After searching for a fix and seeing all the crazy workarounds I found a small comment that got little attention but was the only practical cause and solution.

Here is the probable culprit and solution:Read full article...


Syndicate content

Try2Stop.Us | Contact Us | Log In | Try2Stop.Us © 2011