Remove time from a date and time field? Format removes the displa.
How do I remove time from a date and time field? Format removes the display
but I need to filter to just show unique based on the day. Since the time is part of the field, I am not able to receive the filtering by day. |
=INT(A1)
-- HTH RP (remove nothere from the email address if mailing direct) "oaoboc" wrote in message ... How do I remove time from a date and time field? Format removes the display but I need to filter to just show unique based on the day. Since the time is part of the field, I am not able to receive the filtering by day. |
All times are GMT +1. The time now is 01:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com