Now this is obscure: the 1904 date system in Excel.<\/p>\n
I was working with a spreadsheet in which I was trying to create a
\nprojection of a larger spreadsheet. I.e., I want to be able to
\nshare just a portion of the larger spreadsheet — so I copied the
\nrelevant cells from the larger workbook and pasted them into the
\nshareable workbook as links. Which was fine — except the dates
\nwere all wrong. Right day\/month, wrong year.<\/p>\n
After a few judicious Google searches, I stumbled across the fact that But, here’s the larger picture: I need to share the projected To state the hopefully-obvious: we’re all thoroughly invested in Now this is obscure: the 1904 date system in Excel. I was working with a spreadsheet in which I was trying to create a projection of a larger spreadsheet. I.e., I want to be able to share just a portion … Continue reading
\nthe Mac-created Excel spreadsheet was using the 1904 date system<\/a> as
\na default; unselecting that (in preferences) restored my copied dates
\nto the right year. Victory!<\/p>\n
\nworksheet with staff located at remote offices. A communications
\nnetwork that lets me send data point-to-point is all I need for
\nthat. However, point-to-point (connection-oriented) is not<\/span> appropriate to develop the sort
\nof widespread information network that is the World Wide Web on the
\nInternet. I would not know who to turn to for resolution to this
\nannoying glitch. (The link above is to a Microsoft site; the one that I
\nactually hit at the time was some random user help group). <\/p>\n
\nthis global information service supported by the Internet, and anything
\nthat gets in the way of J. Random Helper posting solutions that S.
\nFrantic User can stumble across is a significant step backwards.<\/p>\n","protected":false},"excerpt":{"rendered":"