Posted to microsoft.public.excel.worksheet.functions

Titanium

external usenet poster

Posts: 46

Date Conversion Formula Needed

From a database some info is generated that reads "20070917 at 1900".
I need to be able to generate "9/17/07 at 19:00"

At first I was thinking I could use a macro to do this, but I have a feeling
there is a much easier formula that can be generated to make the conversion.

Any help will be much appreciated.

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 formula needed	Rich Hayes	Excel Worksheet Functions	4	December 9th 05 07:25 PM
Simple (I Think) Date Formula Needed	Big Rick	Excel Discussion (Misc queries)	4	September 15th 05 01:47 AM
Date formula needed	VDan	Excel Discussion (Misc queries)	4	August 31st 05 04:01 PM
Custom Date formula needed	Yogi_Bear_79	Excel Worksheet Functions	1	June 7th 05 08:45 PM
Need Formula for Date Conversion	Lyle	Excel Worksheet Functions	4	March 31st 05 12:09 AM

All times are GMT +1. The time now is 02:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us