Date/Time format

[Noz2k]

Just a quick question I think

How do I specify the format for date/time if I want it for example to show

18 May 2011 09:30?

 

[Jon von der Heyden]

If the month is to display 3 chars: dd mmm yyyy hh:mm

or if the full month is to be dispayed: dd mmmm yyyy hh:mm

 

[Michael M]

Format Cells
Select Custom and use

d mmm yyyy h:mm

 

[Noz2k]

Thank you