Date and Time in Cells

Hi Rees

Thanks for this. I wanted to know if there was a unique character that separated the date from the time, which in this case there does appear to be (i.e. a space).

Assuming the dates are listed in a column, hopefully this means you should be able to use the Text to Columns feature to split the date away from the time stamp; then just delete the time information as it's not required.

To use Text to Columns:
1. Select the column containing the dates.
2. Go to the Data tab, and click the Text to Columns button.
3. The Text to Columns Wizard will start. At step 1, select Delimited and click Next.
4. At step 2, tick just the Space box. You should see in the preview at the bottom of the wizard that the date and time show in two different columns. Click Next.
5. At step 3, select the column containing the times, and select Do not import column (Skip). Then click Finish.

If the dates remaining still show 00:00 next to them, select the column and reformat it to dd/mm/yyyy. This should get rid of the 00:00

I hope this helps.

Kind regards
Amanda