Thursday, June 26, 2008

Spreadsheet Blegs

A couple of questions, if anyone knows:
  • Sometimes a recently calculated MS Excel cell contains a colon after the number, i.e.
63.1:
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?
Thanks.

No comments: