- Sometimes a recently calculated MS Excel cell contains a colon after the number, i.e.
What does the colon mean?
- I always format my MS Excel cells that are dates as MM/DD/YY. But periodically, about every 2 weeks or so (varies), Excel reformats them as MM/DD/YYYY -- and not just in one spreadsheet, but every spreadsheet I have (or at least, that I have in the same directory). Why does this happen?