Yep, yer probably right. Peculiar, though. I would have...

IWETHEY v. 0.3.0 | TODO

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

Welcome to IWETHEY!

Post #196,045

by CRConrad

2/23/05 2:24:54 AM

Yep, yer probably right. Peculiar, though. I would have...

...thought that Excel would forcibly convert it to a string all by itself, and then taken the right-most sub-string of *that* -- it certainly does enough "helpful" stuff like that when you *don't* want it to, so why on Earth not now? Weirdski.

[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]

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

It's Zeus. He's taking you away to the Acropolis.
52 ms