Re: Converting "Date and Time" to just DATE?

So, is the data in a mixture of formats?

Would you like to send the file to me so I can have a look at it?

pashurst <at> auditel.net

Change the obvious.

I only need the date/time data.

Pete

On Mar 5, 4:53 pm, Robert Blass <bl...@xxxxxxxxxxxxx> wrote:
If the originating data is in the M/D/Y format what you said will
work, but if it's in the D/M/Y format it displays "Jan 1, 00  1pm" etc

On Wed, 5 Mar 2008 07:53:58 -0800 (PST), Pete_UK
<pashu...@xxxxxxxxxxx> sayd the following:



In the examples you quoted earlier you had day-month-year format, but
now you are showing month-day-year - you need to select the
appropriate format in stage 3 of the Text-to-columns wizard.

Pete

On Mar 5, 3:08 pm, Robert Blass <bl...@xxxxxxxxxxxxx> wrote:
On Wed, 5 Mar 2008 04:57:46 -0800 (PST), Pete_UK
<pashu...@xxxxxxxxxxx> sayd the following:

Okay, try this:

Ensure that you have 2 blank columns next to the column with dates,
inserting new columns if necessary. Then highlight the column with
your dates in, click on Data | Text-to-columns and in the Wizard click
on Delimited in the first panel, then Next, then click on Space and
Next, and in the final panel click Date with DMY, amend the
Destination to $B$1 (if your dates are in column A), then click
Finish.

You should end up with just dates in column B and the times in column
C.

Hope this helps.

Pete

Here is what that did
Original                        new                     new
2/29/08 12:00 AM        1/0/00 7:55 AM  AM

It didn't work but maybe their is an extra step needed?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • Re: Converting "Date and Time" to just DATE?
    ... sayd the following: ... I only need the date/time data. ... appropriate format in stage 3 of the Text-to-columns wizard. ... on Delimited in the first panel, then Next, then click on Space and ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Converting "Date and Time" to just DATE?
    ... re-typed all the collumns. ... sayd the following: ... appropriate format in stage 3 of the Text-to-columns wizard. ... on Delimited in the first panel, then Next, then click on Space and ...
    (microsoft.public.excel.worksheet.functions)