View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

If you can live with the date as a text entry enter Sunday then ALT + ENTER
then 3 spaces and 1/1

Format the row to Autofit.

Gord Dibben Excel MVP

On Fri, 3 Dec 2004 16:08:30 -0800, ".:mmac:." <lost@sea wrote:

I keep running into that problem.
Thanks.

"Frank Kabel" wrote in message
...
Hi
AFAIK this is not possible

--
Regards
Frank Kabel
Frankfurt, Germany

".:mmac:." <lost@sea schrieb im Newsbeitrag
...
I have a single cell set to display the date as

Sun, 1/1

and I would prefer it to be centered on two lines in the cell like:

Sunday
1/1

When entering text it is done using the Alt key but how can I do it

with a
cell custom format?