Hello!
I have a file that has the Date and Time combined into one cell. I want to separate the two, and cannot find anywhere on the net to do so!
This is the cells format:
d/mm/yyyy h:mm
Cells look like this:
28/05/2008 12:30
Does anyone know how to separate these with VBA code? changing the cell format changes the look of the cell, but the underlying numbers are still the same. Any ideas?
Cheers
Bookmarks