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

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

I suspect these are probably text values that just look like dates.
What happens if you highlight the column, do Format | Cells | Number
tab then click on Number with 2dp and OK? Do you get numbers, or do
the displays stay the same?

Pete

On Mar 5, 11:45 am, Robert Blass <bl...@xxxxxxxxxxxxx> wrote:
No, that didn't work.

Here is an example of the cells.

5/3/08 6:23 AM
3/3/08 7:06 PM
2/3/08 3:55 PM
2/3/08 10:07 AM
29-02-2008 07:55 AM
29-02-2008 07:51 AM
29-02-2008 07:37 AM
28-02-2008 07:57 AM
28-02-2008 07:56 AM
28-02-2008 07:54 AM
27-02-2008 08:39 PM
27-02-2008 02:58 PM
27-02-2008 02:56 PM
27-02-2008 11:32 AM
27-02-2008 11:31 AM
26-02-2008 10:19 AM
26-02-2008 07:23 AM
25-02-2008 05:28 PM
25-02-2008 05:26 PM

Notice some are m/d/year and some are d/m/year

thanks

On Wed, 5 Mar 2008 03:42:37 -0800 (PST), Pete_UK
<pashu...@xxxxxxxxxxx> sayd the following:



You can apply a custom format to the cells so that only the date is
displayed (but the time is still included within the data), eg mmm dd,
yyyy.

If you want to get rid of the time part completely, then use this
formula in an adjacent column:

=INT(A1)

and format the cell as a date, and then copy down.

Hope this helps.

Pete

On Mar 5, 11:34 am, Robert Blass <bl...@xxxxxxxxxxxxx> wrote:
I have a large number of cells with date and time like this, "Jan 12,
2001 5:55 pm"
I want to truncate the time in the cell and only make it display the
date.

Can someone help me?- Hide quoted text -

- Show quoted text -

.

Relevant Pages

  • All words and Symbols of keybord should be added to Auto Shapes
    ... Suggestions are both for Word and Excel where applicable. ... Transpose should have an extra facility to transpose the selected cells ... display begins in the second line and therefore we cannot see row name A, B, ... And more in a single selection at a time, then there will be no problem. ...
    (microsoft.public.excel.misc)
  • Re: concatenation
    ... To display the phone numbers with a hyphen, you can use a number format: ... Select the cells that contain the phone numbers ... Select the Number tab ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Automatically change cell reference?
    ... Are there any empty/blank cells *within* the range? ... the entry row. ... was pointing to February will advance one column to now display March ... extensive file that has a tab that is just for the display board, ...
    (microsoft.public.excel.misc)
  • Re: How do I prevent Excel from putting 16 digit numbers into scienti.
    ... You should format the cells as "Text" *before* you enter the numbers. ... > union) and I want Excel to stop storing the numbers in the column as ... I can change formats and make the number display ...
    (microsoft.public.excel.misc)
  • Re: Date and number not displayed correctly
    ... What exactly do you mean by "the format of the cells is not correct"? ... What font is used? ...  Look at the Display control panel. ...
    (microsoft.public.excel.misc)