Al's question looks like string literals are what it's about

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #195,997 by CRConrad 2/22/05 4:30:56 PM 2/22/05 4:31:13 PM Reply	Al's question looks like string literals are what it's about Edited by CRConrad Feb. 22, 2005, 04:31:13 PM EST Expand All History
Post #195,998 by pwhysall 2/22/05 4:31:42 PM Reply	Looks like Excel's default rendition of a date/time serial Peter [link\|http://www.ubuntulinux.org\|Ubuntu Linux] [link\|http://www.kuro5hin.org\|There is no K5 Cabal] [link\|http://guildenstern.dyndns.org\|Home] Use P2P for legitimate purposes!
Post #196,044 by CRConrad 2/23/05 2:18:14 AM Reply	Default? On Yank Winders, perhaps, yes... ...but not on mine (and not on yours, I'd have thought), where the default Windows date and time formats -- which Excel obeys, AFAIK -- are different. I mean, as long as you want to be quite exact about these things... (And people call me "anal"?!?) [link\|mailto:MyUserId@MyISP.CountryCode\|Christian R. Conrad] (I live in Finland, and my e-mail in-box is at the Saunalahti company.) Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link\|http://z.iwethey.org/forums/render/content/show?contentid=71575\|Ashton Brown]
Post #196,048 by pwhysall 2/23/05 3:25:53 AM Reply	Al's Winders will be Yankish, I wot. Peter [link\|http://www.ubuntulinux.org\|Ubuntu Linux] [link\|http://www.kuro5hin.org\|There is no K5 Cabal] [link\|http://guildenstern.dyndns.org\|Home] Use P2P for legitimate purposes!
Post #196,051 by CRConrad 2/23/05 3:50:57 AM Reply	Quite possib -- hey, quite probable, even! ;-)
Post #196,065 by ChrisR 2/23/05 9:44:53 AM Reply	And they'll all buffer overflow on 12/31/2024
Post #196,066 by CRConrad 2/23/05 9:46:57 AM Reply	Why then; izzat when Al's Social Security runs out, or...?

Excel Question - (alvitale) - (20) - Feb. 22, 2005, 04:24:57 PM EST

If that's an actual time... - (pwhysall) - Feb. 22, 2005, 04:27:40 PM EST

Enter in TargetCell: "=Right(SourceCell, 12)" HTH! (HTW :-) -NT - (CRConrad) - (8) - Feb. 22, 2005, 04:28:56 PM EST

Will only work for string literals - (pwhysall) - (7) - Feb. 22, 2005, 04:29:29 PM EST

Al's question looks like string literals are what it's about -NT - (CRConrad) - (6) - Feb. 22, 2005, 04:31:13 PM EST

Looks like Excel's default rendition of a date/time serial -NT - (pwhysall) - (5) - Feb. 22, 2005, 04:31:42 PM EST

Default? On Yank Winders, perhaps, yes... - (CRConrad) - (4) - Feb. 23, 2005, 02:18:14 AM EST

Al's Winders will be Yankish, I wot. -NT - (pwhysall) - (3) - Feb. 23, 2005, 03:25:53 AM EST

Quite possib -- hey, quite *probable*, even! -NT - (CRConrad) - (2) - Feb. 23, 2005, 03:50:57 AM EST

And they'll all buffer overflow on 12/31/2024 -NT - (ChrisR) - (1) - Feb. 23, 2005, 09:44:53 AM EST

Why then; izzat when Al's Social Security runs out, or...? -NT - (CRConrad) - Feb. 23, 2005, 09:46:57 AM EST

Use text->column - (bepatient) - (2) - Feb. 22, 2005, 06:29:15 PM EST

People! - (pwhysall) - (1) - Feb. 23, 2005, 01:40:12 AM EST

Yep, yer probably right. Peculiar, though. I would have... - (CRConrad) - Feb. 23, 2005, 02:24:54 AM EST

If Peter is right, and that's a numeric date-time value... - (CRConrad) - (4) - Feb. 23, 2005, 02:50:54 AM EST

Correct - (bepatient) - (3) - Feb. 23, 2005, 07:10:49 AM EST

/me falls over - (pwhysall) - (1) - Feb. 23, 2005, 07:12:16 AM EST

Settle down fella - (bepatient) - Feb. 23, 2005, 02:37:50 PM EST

Well, yes- but maybe he wants the original one *also*. (Al?) - (CRConrad) - Feb. 23, 2005, 09:44:12 AM EST

If you want a text result... - (Steven A S) - (1) - Feb. 23, 2005, 03:33:19 PM EST

Thanks to all who contributed. I didn't respond to the - (alvitale) - Feb. 25, 2005, 04:27:25 PM EST

iwethey.org

Shocking, but not surprising.
55 ms