how to change date 20080115 to 15/01/2008?

's Computer Specifications

's Computer Specifications

Try this, with your number in A1:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

Hope this helps.

Pete

On Jun 25, 7:01*am, Soozler <Sooz...@discussions.microsoft.com> wrote:
>

's Computer Specifications

Data/ Text to Columns/ Delimited/ Next/ Next/ Date : YMD

And next time, please ask the question in the message body, not just in the
subject line.
--
David Biddulph

"Soozler" <(E-Mail Removed)> wrote in message
news:721614DA-1266-438D-8116-(E-Mail Removed)...
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
In Word 2008 how can I change the default NOT to change 1/2 to sm.	Quilter60	Microsoft Word Document Management	1	22nd Dec 2009 11:18 PM
How to change January 2008 to 1/1/2008	Chuck M	Microsoft Access VBA Modules	3	27th Aug 2008 01:52 PM
How to format date from e.g 10/2/2008 to 10-Feb-2008	rote	Microsoft ASP .NET	2	18th Jul 2008 09:12 AM
2008 new year,2008 new business, 2008 new life, much cheap and beautiful product will help you which r u like ?	yhnetstore5@gmail.com	Microsoft C# .NET	0	5th Jan 2008 07:18 PM
FREE DOWNLOAD 2008's SOFTWARE: XSTEEL 13,AUTOCAD 2008,AUTODESK VIZ 2008,ANSYS 11!	CD-SOFT2007	Microsoft ASP .NET	0	18th Jul 2007 05:39 PM