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

Tech-Archive recommends: Fix windows errors by optimizing your registry

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 -

.

Relevant Pages

  • Re: how to best approach a massive list?
    ... all primarily text with the display showing up in table format. ... one table would show the 3 primary items. ...
    (alt.html)
  • Re: how to best approach a massive list?
    ... all primarily text with the display showing up in table format. ... one table would show the 3 primary items. ...
    (alt.html)
  • Re: Help With Conditional Formatting
    ... format and to the intermediate parameters which we've been looking at. ... If you're convinced that you've got red showing ... To cut a long story short, my spreadsheet has 3 columns I would ... Column K is the requested delivery date from the customer, ...
    (microsoft.public.excel.misc)
  • Re: Ultra 5 and large Hard drives - n00b ?
    ... labeled the drive with a partition and it only showed half a gig. ... Then I saw that it was only showing, if I recall, only 500 or so of the ... So I used the format, disk command and was able to enter that it really has ...
    (comp.sys.sun.hardware)
  • RE: Need to Format Currency without changing values - over 16,0000
    ... Is there any way to format what is showing? ... "Sheeloo" wrote: ... If you select the cell showing 18 and look in the EDIT BOX you will see it ... To get my email id paste my address in an Excel cell and press Enter... ...
    (microsoft.public.excel.misc)