Posted to microsoft.public.excel.misc

Port Man

external usenet poster

Posts: 6

Date Conversion

1. I have cells that have dates in the format of yyyymmdd and I want
to change them into mmddyyyy.

2. Also, I want to make another column that will have the mmddyyyy
converted to unix date format.

3. Text in some cells are all in UPPERCASE and I want to convert it to
lowercase. Is this possbile?

Thank you.
--

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	MIchel Khennafi	Excel Worksheet Functions	3	July 20th 06 05:56 PM
Date conversion	Stephanie Myers	Excel Worksheet Functions	5	July 18th 05 08:59 PM
Date Conversion	Jesse	Excel Worksheet Functions	2	April 20th 05 06:57 PM
date conversion	rdunne	Excel Worksheet Functions	2	April 12th 05 10:41 PM

All times are GMT +1. The time now is 04:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us