Forum Discussion
How to Remove Time Stamp from Date
Good Morning, As seen in the picture below I need to remove the time stamp from these cells. I've have tried just changing the number format for that colum but it wont work. I feel like I've wat...
From the discussion this far, I suspect the date and timestamp to be nothing more than a bit of text that Excel has failed to recognise as a date.
If so,
= LEFT(timestamp, SEARCH(" ", timestamp)-1)
should return the date as text, terminating just before the first space.
If required, placing '--' before the 'LEFT' should coerce the text to a (numeric) Excel date.