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

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

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
<pashurst@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?

.

Relevant Pages

  • Re: Can General format numbers be mistaken as text?
    ... how many digits that may be. ... It's fine if you want to use General format. ... Perhaps your coworker is worried that there may be situations where Excel will change the cell format from General to Text automagically, just as it changes from General to Number, Currency or Percentage. ... mean it will "display whatever the user types" exactly as it is entered. ...
    (microsoft.public.excel.misc)
  • Re: Can General format numbers be mistaken as text?
    ... I believe that his concern is that without an explicit "Number" format, ... mean it will "display whatever the user types" exactly as it is entered. ... there are many instances where the content of a General cell is not ...
    (microsoft.public.excel.misc)
  • RE: Formatting and Ignore error
    ... The following procedure builds a custom format for integers by adding the ... 'Initialize cell alignments to a common starting point ... To remove this triangle, I select the ... display 5.30; presumably 5.809 would display 5.81 truncation is OK, ...
    (microsoft.public.excel.programming)
  • Re: DataGridView custom function?
    ... The best thing would be if the original data could do a join on whatever table has the text data, and return that for display. ... capture the Format event on each cell and go get the province. ... ByVal e as DataGridViewCellFormattingEventArgs) ...
    (microsoft.public.dotnet.framework)
  • Re: Concatented Numbers Display as Scientific Notation
    ... You could give that cell a nice number format and not have to worry about what ... excel likes to do: ... > As noted, the actual value is ok, just the display is "wonky". ...
    (microsoft.public.excel.programming)