Hi,

I have column having date and timestamp together, all i want is t
remove the time stamp.. i want only date has to be displayed.. i can d
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.
Vasikara

--
r.vasikara
-----------------------------------------------------------------------
r.vasikaran's Profile: http://www.excelforum.com/member.php...fo&userid=3440
View this thread: http://www.excelforum.com/showthread.php?threadid=54179

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

HTH
--
AP

"r.vasikaran" <(E-Mail Removed)> a
écrit dans le message de news:
(E-Mail Removed)...
>
> 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
>

i got the answer..

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

this will truncate the timestamp from the date format


thank

--
r.vasikara
-----------------------------------------------------------------------
r.vasikaran's Profile: http://www.excelforum.com/member.php...fo&userid=3440
View this thread: http://www.excelforum.com/showthread.php?threadid=54179