Date time Format

[dommy575]

Morning Guys

I need to format row A so it shows both the date and time - i have tried a custom format (in row B) that was dd/mm/yyyy hh:mm however it brings up the incorrect time in row b

any ideas?

help is much appreciated

 

[awoohaw]

try this custom format first:
dd-mm-yyyy hh:mm:ss, if that looks right, then remove the ss on next step.
if it fails, then post a screen shot of the cell number format dialog box when B3 is selected so we can see the formatting and the formula in the formula bar.

 

[dommy575]

brilliant - that's worked a treat - thank you for the help

 

[awoohaw]

Happy to help.
Best Wishes!