Removing hh:mm:ss from date

  • Thread starter Thread starter KrisP
  • Start date Start date
K

KrisP

How can i remove the hh:mm:ss from the end of a date? I've converted it to
just date, and it looks as its just date but if you click on the cell you can
still see the time. I want to be able to group a list by date only and
cannot get ride of the time extension.

Many thanks in advance for your help.
 
Are the dates hard coded or the result of a formula? If hard coded, are you
talking about physically changing the values in the cells or would a new
column with the date only be acceptable?

Rick
 
Sorry, new to all this. They are in a pivot table. I've copied them out of
the pivot table and pasted into cells. A new column would be fine.
 
=INT(A1) gives just the date
=MOD(A1,1) gives just the time
Format the cells accordingly.
 
Back
Top