Value of a date in Numbers
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