Posted to microsoft.public.excel.worksheet.functions

Gord Dibben Gord Dibben is offline

external usenet poster

Posts: 22,906

How can I change 080402 to 08/04/02?

DataText to ColumnsNextNextColumn Data FormatDateDMY and Finish.

Gord Dibben MS Excel MVP

On Fri, 3 Nov 2006 12:07:02 -0800, Bobbie
wrote:

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
How do I have the date in a spreadsheet change automically.	VC	Excel Discussion (Misc queries)	1	September 29th 06 09:05 AM
How do I have the date in a spreadsheet change automically.	VC	Excel Discussion (Misc queries)	1	September 29th 06 02:37 AM
Want cell ref. to change after sort in other sheet	Bullfn33	Excel Discussion (Misc queries)	1	August 6th 06 05:48 PM
Find function	alamo	Excel Worksheet Functions	1	September 16th 05 02:01 PM
Find function	alamo	Excel Worksheet Functions	1	September 16th 05 12:47 PM

All times are GMT +1. The time now is 12:42 AM.

About Us

"It's about Microsoft Excel"