Hello
Apologies if this has been solved previously - i have a number of dates on Sheet1, ie (=NOW() +1/48) and use those in Sheet2 as a dropdown list. The cell it goes into on Sheet2 is not wide enough for (06/09/2022 13:00:00) on 1 line. I need it to be Date & Chr(10) & Time as below.
06/09/2022
13:00:00
I cant seem to format using Format Cell correctly and wondered if i could with vba?
Apologies if this has been solved previously - i have a number of dates on Sheet1, ie (=NOW() +1/48) and use those in Sheet2 as a dropdown list. The cell it goes into on Sheet2 is not wide enough for (06/09/2022 13:00:00) on 1 line. I need it to be Date & Chr(10) & Time as below.
06/09/2022
13:00:00
I cant seem to format using Format Cell correctly and wondered if i could with vba?