blackie42
08-15-2017, 04:29 AM
Hi
Downloading a report and column J is formatted as follows
d-mmm-yyyy hh:mm:ss
e.g 14-Aug-2017 01:00:46
Trying to copy this to adjacent cells in column N and using RIGHT function to isolate the date however it just returns a number.
Copying the original and reformatting to hh:mm:ss does show the time but clicking the cell it's just hiding the date i.e. click back on the cell and
the date is still there.
Any way to get the cell just to contain the trimmed date?
thanks
Jon
Downloading a report and column J is formatted as follows
d-mmm-yyyy hh:mm:ss
e.g 14-Aug-2017 01:00:46
Trying to copy this to adjacent cells in column N and using RIGHT function to isolate the date however it just returns a number.
Copying the original and reformatting to hh:mm:ss does show the time but clicking the cell it's just hiding the date i.e. click back on the cell and
the date is still there.
Any way to get the cell just to contain the trimmed date?
thanks
Jon