Hi All,
I have a column in my sheet which contains text and numbers. The numbers refer to the date but in a US format. I need to convert this to UK format as these cells are then used to count days. I have searched around the web and cannot find anything that works.
Thanks in advance
Blunder
I have a column in my sheet which contains text and numbers. The numbers refer to the date but in a US format. I need to convert this to UK format as these cells are then used to count days. I have searched around the web and cannot find anything that works.
Thanks in advance
Blunder