On Feb 25, 8:05*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
I don't think you'll be able to do it in formatting, but try
=UPPER(TEXT(A1,"hh:mm ddd dd.mm.yy "))
--
David Biddulph

"robzrob" wrote in message

...



I've got a cell formatted thus: hh:mm ddd dd.mm.yy which returns 19:20
Thu 25.02.10. *I want 19:20 THU 25.02.10, ie the day in caps.- Hide quoted text -

- Show quoted text -

Thanks, it works - I didn't think it would because I've got =NOW() in
the cell - but it does!