Posted to microsoft.public.excel.misc

external usenet poster

Posts: 6

Date Conversion

I'm looking for the following formulas:

1. I have cells that have dates in yyyymmdd format and I want to
convert them to mmddyyyy format.

2. I want to make another column with the mmddyyyy format and convert
it to unix date/time.

3. Convert a cell with all UPPERCASE to all lowercase.

Thanks.

--

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date conversion	Tom	Excel Discussion (Misc queries)	7	January 2nd 07 09:47 PM
Date Conversion - sorry	DTTODGG	New Users to Excel	5	December 13th 05 07:36 PM
Date conversion	Stephanie Myers	Excel Worksheet Functions	5	July 18th 05 08:59 PM
Date Conversion	JD McLeod	Excel Worksheet Functions	1	June 17th 05 01:07 PM
date conversion	rdunne	Excel Worksheet Functions	2	April 12th 05 10:41 PM

All times are GMT +1. The time now is 10:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us