date/time format with carriage returnt

[jamada]

Hi, any thoughts/solution son how I can have the date/time as indicated in code below.
I would like same cell to display date top line, carriage return and time below date, all same cell.

The following doesn't quite do it


Cells(1, "A").Value = Format(Now(), "ddmmmyy & Chr(10)HH:mm ")


thanks Graham

 

[mumps]

Try:

Cells(1, "A").Value = Format(Now(), "ddmmmyy" & Chr(10) & "HH:mm ")

 

[jamada]

mumps, I could have sworn I tried that? BUT Thank you, much appreciated!

Graham

 

[mumps]

You are very welcome.