On Feb 25, 8:12*pm, Ron Rosenfeld wrote:
On Thu, 25 Feb 2010 11:22:04 -0800 (PST), robzrob wrote:
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.

I don't believe you can do that with formatting. *I think the only way to get
that display is with a formula, such as:

=UPPER(TEXT(NOW(),"hh:mm ddd dd.mm.yy"))

Of course, now you are dealing with a text string which will make it difficult
to use in calculations downstream.

If that is important, you might separate your data/entry-computation cell from
the display cell.

--ron

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