UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

Excel question	by ihatewindoze	2002-11-11 07:26:28
You could	by hyzenthlay	2002-11-11 07:37:13
use text-to-column (under the Data menu) on your results. Just tell it to use fixed width, take out any columns it puts in and format the column as a date in the final step. I have to do that all the time with numbers from clients, they get input as text and I use text-to-column to turn them back into numbers.
[ Reply ]
works nice, but the year is chopped and everything	by plblark	2002-11-11 07:46:48
Well	by hyzenthlay	2002-11-11 07:55:48
good idea...	by plblark	2002-11-11 07:59:14
or use my trim formula	by ihatewindoze	2002-11-11 08:07:17
sometimes, though, the macro	by plblark	2002-11-11 08:09:19
yeah, that works	by ihatewindoze	2002-11-11 08:13:14
Don't know	by hyzenthlay	2002-11-11 08:09:19
Hey cool. Thanks, that worked (n/t)	by ihatewindoze	2002-11-11 07:52:31
Glad to hear it! (n/t)	by hyzenthlay	2002-11-11 07:56:42

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)