date without timestamp

[r.vasikaran]

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

 

[Ardus Petus]

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

HTH

 

[r.vasikaran]

i got the answer..

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

this will truncate the timestamp from the date format


thank