Need help formatting cells

[Vinish]

Hi,

I have a cell with a date value. The format displayes is in the following
order: 5/16/2005 4:25:32 PM

I need to convert this so that the time does'nt show up. In other words I
just need to see 5/16/2005.

Is there a way I can do this in excel without using VB.

Thanks!!

[N Harkawat]

just format it using
cells-format-date-and select the format that matches what you need

"Vinish" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a cell with a date value. The format displayes is in the following
> order: 5/16/2005 4:25:32 PM
>
> I need to convert this so that the time does'nt show up. In other words I
> just need to see 5/16/2005.
>
> Is there a way I can do this in excel without using VB.
>
> Thanks!!

[Vinish]

Yeah thats exactly what I did, however int he formula bar the time still
shows up.

Also I need to plot a graph based on dates and due to the fact that the time
comes in, it does'nt work out too well.


"N Harkawat" wrote:

> just format it using
> cells-format-date-and select the format that matches what you need
>
> "Vinish" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I have a cell with a date value. The format displayes is in the following
> > order: 5/16/2005 4:25:32 PM
> >
> > I need to convert this so that the time does'nt show up. In other words I
> > just need to see 5/16/2005.
> >
> > Is there a way I can do this in excel without using VB.
> >
> > Thanks!!
>
>
>

[Ron Rosenfeld]

On Fri, 20 May 2005 08:40:09 -0700, Vinish <[email protected]>
wrote:

>Yeah thats exactly what I did, however int he formula bar the time still
>shows up.
>
>Also I need to plot a graph based on dates and due to the fact that the time
>comes in, it does'nt work out too well.

It sounds like what you want to do is eliminate the time from the cell, as
opposed to having it "not show up" in the cell.

In order to not use VB, you need to truncate the decimal portion of the
date/time entries. If your data is in A1:An, in some unused column, enter the
formula =INT(A1) and copy the formula down to Row n.

Then, either use that column in your graph, or select it, and do a copy / paste
special: values back over the original data.


--ron

[Vinish]

That did it... thanks very much Ron.

Cheers,
Vinish

"Ron Rosenfeld" wrote:

> On Fri, 20 May 2005 08:40:09 -0700, Vinish <[email protected]>
> wrote:
>
> >Yeah thats exactly what I did, however int he formula bar the time still
> >shows up.
> >
> >Also I need to plot a graph based on dates and due to the fact that the time
> >comes in, it does'nt work out too well.
>
> It sounds like what you want to do is eliminate the time from the cell, as
> opposed to having it "not show up" in the cell.
>
> In order to not use VB, you need to truncate the decimal portion of the
> date/time entries. If your data is in A1:An, in some unused column, enter the
> formula =INT(A1) and copy the formula down to Row n.
>
> Then, either use that column in your graph, or select it, and do a copy / paste
> special: values back over the original data.
>
>
> --ron
>

[Ron Rosenfeld]

On Fri, 20 May 2005 11:40:24 -0700, Vinish <[email protected]>
wrote:

>That did it... thanks very much Ron.
>
>Cheers,
>Vinish

You're welcome. Thank you for the feedback.


--ron

[bj]

What happens when you format it general? If it doesnt change, it is text
in this case try putting 1 in a cell copying that cell. Selecting the Date
cell and paste special multiply.
see if the format changes now.

"Vinish" wrote:

> Yeah thats exactly what I did, however int he formula bar the time still
> shows up.
>
> Also I need to plot a graph based on dates and due to the fact that the time
> comes in, it does'nt work out too well.
>
>
> "N Harkawat" wrote:
>
> > just format it using
> > cells-format-date-and select the format that matches what you need
> >
> > "Vinish" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi,
> > >
> > > I have a cell with a date value. The format displayes is in the following
> > > order: 5/16/2005 4:25:32 PM
> > >
> > > I need to convert this so that the time does'nt show up. In other words I
> > > just need to see 5/16/2005.
> > >
> > > Is there a way I can do this in excel without using VB.
> > >
> > > Thanks!!
> >
> >
> >