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" wrote in message
...
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!!