You can format the cell where the formula is as...Time. - Kills the date and
shows only the time.

"Callan" wrote:

Hi. I need the "now()" syntax to only return the date, without the time stamp.
Is this possible? Help would be much appreciated.
Many thanks
--
Callan