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?