• Home

KnitBot

Don’t take it all too seriously…

Feed on
Posts
Comments

Obscuratum

Dec 10th, 2008 by knitbot

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 of the larger spreadsheet — so I copied the
relevant cells from the larger workbook and pasted them into the
shareable workbook as links.  Which was fine — except the dates
were all wrong.  Right day/month, wrong year.

After a few judicious Google searches, I stumbled across the fact that
the Mac-created Excel spreadsheet was using the 1904 date system as
a default; unselecting that (in preferences) restored my copied dates
to the right year.  Victory!

But, here’s the larger picture:  I need to share the projected
worksheet with staff located at remote offices.  A communications
network that lets me send data point-to-point is all I need for
that.  However, point-to-point (connection-oriented) is not appropriate to develop the sort
of widespread information network that is the World Wide Web on the
Internet. I would not know who to turn to for resolution to this
annoying glitch. (The link above is to a Microsoft site; the one that I
actually hit at the time was some random user help group). 

To state the hopefully-obvious:  we’re all thoroughly invested in
this global information service supported by the Internet, and anything
that gets in the way of J. Random Helper posting solutions that S.
Frantic User can stumble across is a significant step backwards.

Posted in All, Net Working | No Comments

Comments are closed.

  •  

    December 2008
    M T W T F S S
    « Nov   Jan »
    1234567
    891011121314
    15161718192021
    22232425262728
    293031  
  • Meta

    • Log in
    • Entries RSS
    • Comments RSS
    • WordPress.org
  • Links

    • Diversion

      • Cute Overload
      • I Can Has Cheezburger? (lolcats)
      • The Daily Kitten
    • Links

      • KnitBot FO Gallery
  • Archives

    • January 2012
    • November 2011
    • October 2011
    • February 2011
    • January 2011
    • December 2010
    • November 2010
    • August 2010
    • July 2010
    • May 2010
    • February 2010
    • January 2010
    • November 2009
    • July 2009
    • June 2009
    • April 2009
    • March 2009
    • January 2009
    • December 2008
    • November 2008
    • September 2008
    • July 2008
    • May 2008
    • March 2008
    • June 2007
    • May 2007
    • April 2007
    • March 2007
    • February 2007
  • Categories

    • All
    • Diversion
    • Food
    • Knitting
    • Misc
    • Net Working
    • Photo Op
    • Weaving
    • Pages displayed : 50320
    • Unique visitors : 11326
    • Pages displayed in last 24 hours : 25
    • Unique visitors in last 24 hours : 13
    FireStats icon Powered by FireStats
  • Popular posts

    • Truly Fowl Holidays
    • Leaning Tower of Cake
    • Dragon Hide Baby Blanket!
    • When a Good Cookie Goes Bad…
    • Eccentric
    • Cheese: an Explanation
    • Taipei Wonders #2
    • Newton v. Air
    • Tagine -- You're It!
    • Taipei Wonders #1

    FireStats icon Powered by FireStats

KnitBot © 2012 All Rights Reserved.

MistyLook made free by Web Hosting Bluebook


50320 pages viewed, 25 today
11326 visits, 13 today
FireStats icon Powered by FireStats