• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Value of a date in Numbers
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Value of a date in Numbers


  • Subject: Value of a date in Numbers
  • From: Michelle Steiner <email@hidden>
  • Date: Mon, 2 Feb 2009 19:41:26 -0700

value of a cell, when the cell is formated as a time (or date-time) returns Greenwich Mean Time instead of the local date displayed in the spreadsheet.

I didn't discover this "feature"; I learned of it from someone else. But is it a bug or is it as designed?

It does mean that when using that time in other applications, such as creating an event in iCal, you have to subtract "time to GMT" from it to get the correct time in the event.

-- Michelle

--
Never play strip Tarot.

_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden
  • Follow-Ups:
    • Re: Value of a date in Numbers
      • From: Luther Fuller <email@hidden>
    • Re: Value of a date in Numbers
      • From: email@hidden
    • Re: Value of a date in Numbers
      • From: KOENIG Yvan <email@hidden>
  • Prev by Date: Re: Excel: finding last used cell in a range
  • Next by Date: path to a script
  • Previous by thread: Numbers again
  • Next by thread: Re: Value of a date in Numbers
  • Index(es):
    • Date
    • Thread