How to create a Custom Date Time Format

[dominicm]

Hello, if I right click on a cell and goto, format cells, number, custom there are lots of options for the format of date and time.
dd-mmm-yy hh:mm is not one of the existing formats and I would like to be able to add it if possible?
thanks.

[adhawan06]

Hello dominicm - It's nice to see you again.

It's very easy, follow the same steps after going into Format Cells : Format Cells-->Custom--> And type the date format which you want (in your case it will be dd-mmm-yy hh:mm)

Format Cell Answers.png

I hope it will work

[dominicm]

Hi Any, you are correct that was an easy one to fix, if only I had of tried to type in the first place, I was thinking I was going to have to go through some customising options to get a non standard format to appear!! Well I am learning so that is good!! thanks again :-)

[adhawan06]

Nice to see that people are learning on this knowledge sharing platform.

Would love to hear you soon.