Re: reformat cells for date

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I don't know. My short date format is: mm/dd/yyyy (4 digit year)

I've had trouble with this techique before, but I closed excel and reopened it
and it continued to work.

When I've had trouble, I'll use the helper column and a formula like:
=text(a1,"000000")
convert to values
and use data|text to columns.

David Biddulph wrote:

Perhaps it's dependent on Windows Regional Options?
--
David Biddulph

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:47F3E7A7.680BE737@xxxxxxxxxxxxxxxxxxx
It worked for me in xl2003--as long as the year was only two digits.

If I used 4 digit years, then it didn't work right.

This:
51208
61208
71208
81208
91208
101208
111208
121208

converted to:
05/12/2008
06/12/2008
07/12/2008
08/12/2008
09/12/2008
10/12/2008
11/12/2008
12/12/2008

And this:

50308
60308
70308
80308
90308
100308
110308
120308

Converted to:

05/03/2008
06/03/2008
07/03/2008
08/03/2008
09/03/2008
10/03/2008
11/03/2008
12/03/2008



David Biddulph wrote:

I had wondered about that method, but for me that doesn't work with
51208,
though it does work with 201208.
--
David Biddulph

"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:47F38CC5.BC988F7C@xxxxxxxxxxxxxxxxxxx
Select the column with the "dates"
Data|Text to columns (in xl2003 menus)
Fixed width, but remove any lines that excel guessed.
Choose Date and dmy
and drop the data right back into its original location.

Then format that column the way you like.

Wackyracer wrote:

I have a csv file that contains a column with dates in it.
Unfortunately
the
column has the information entered as DMMYY for 5/12/08 or DDMMYY for
20/12/08. So for days 1st to 9th there is no 0 at the front end.

I need to be able to change this coloumn so it reads DD/MM/YYYY so I
can
import it into another programme. Can any help?

Many thanks

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson
.

Relevant Pages