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" 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!!