Date Extract Issue - Formatting

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
623
Hi Excel Guru's

I have a data extraction ( sounds painful , but isn't )
from a piece of electrical testing software.

Have downloaded from csv file into workable spreadsheet.

My problem is with the "test date " & "re test date" columns.

Data comes into Excel as 20050905 , i would like to convert
to 05/09/2005.

I have tried text to columns , but for some strange reason
it extends the result over three colomns !!!!!

Any help on this date conversion would be grately appreciated.

Keep up the good work

Russ.
 

AgentSmith

Well-known Member
Joined
Mar 8, 2004
Messages
575
You can convert it using a formula, if that's any good:
Code:
=DATE(VALUE(LEFT(cell,4)),VALUE(MID(cell,5,2)),VALUE(RIGHT(cell,2)))
That cuts it down to 2 columns, I guess.
 

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
With AgentSmith's formula I think this is a good way to go.

I nowadays import everything as text and convert afterwards because Excel can sometimes convert imported dates into different formats in the same column.
 

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
623
AgentSmith , BrianB,

Thank you very much , works like a dream !!!

Keep On Excelling !!!! :biggrin:

Russ
 

Forum statistics

Threads
1,078,070
Messages
5,338,035
Members
399,198
Latest member
PsycholoJackal

Some videos you may like

This Week's Hot Topics

Top