date without timestamp

Hi,

I have column having date and timestamp together, all i want is to remove the time stamp.. i want only date has to be displayed.. i can do that in format section, but on doing , in display i can see only date, but on the top i can see the timestamp along with the date..

pls help.

many thanks.
Vasikaran

i got the answer..

actually we need to use as =int(cell no)

this will truncate the timestamp from the date format


thanks

If timestamp is in A1, enter in B1: =INT(A1)

HTH
--
AP

"r.vasikaran" <[email protected]> a
écrit dans le message de news:
[email protected]...
>
> Hi,
>
> I have column having date and timestamp together, all i want is to
> remove the time stamp.. i want only date has to be displayed.. i can do
> that in format section, but on doing , in display i can see only date,
> but on the top i can see the timestamp along with the date..
>
> pls help.
>
> many thanks.
> Vasikaran
>
>
> --
> r.vasikaran
> ------------------------------------------------------------------------
> r.vasikaran's Profile:
> http://www.excelforum.com/member.php...o&userid=34400
> View this thread: http://www.excelforum.com/showthread...hreadid=541792
>