Correct

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

Welcome to IWETHEY!

Post #196,053 by bepatient 2/23/05 7:10:49 AM Reply	Correct if its simply a format issue...copy the cell directly and change the format. If you push something hard enough, it will fall over. _{Fudd's First Law of Opposition} [link\|mailto:bepatient@aol.com\|BePatient]
Post #196,054 by pwhysall 2/23/05 7:12:16 AM Reply	/me falls over You owe me a beer! :-p 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,112 by bepatient 2/23/05 2:37:50 PM Reply	Settle down fella You'll get plenty of them in a couple months. If you push something hard enough, it will fall over. _{Fudd's First Law of Opposition} [link\|mailto:bepatient@aol.com\|BePatient]
Post #196,064 by CRConrad 2/23/05 9:44:12 AM Reply	Well, yes- but maybe he wants the original one also. (Al?) Also, "=[Left-Arrow]" (or whatever) gives a neat and easy value to copy down into a lot of cells, if he actually has a whole column of values he wants to change(). Oh well, a matter of taste, I suppose; YMMV. (): Get a correct value/format into the topmost one, Al, and then "paint" (i.e, multi-select) the rest of them by click-dragging with the mouse, or pressing shift-[Down-Arrow]; then finally press Ctrl-D. [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

Trust me...
87 ms