Help cell formatting.
 

Hi all,

I would format a cell to show informatios as below:

05/13/2004
Thursday

NOTE:
I don't want a formula. I would use the format options.
The alfanumeric string must be under the numeric one.
Note the first capital letter.

I tried "mm/dd/yyyy dddd" but it returns

05/13/2004 thursday

(on the same line).

Do you know some tricks to do this?

Thank you, Alex.

Help cell formatting.
 

Hi
AFAIK this is not possible using a cell format

--
Regards
Frank Kabel
Frankfurt, Germany


y wrote:
Hi all,

I would format a cell to show informatios as below:

05/13/2004
Thursday

NOTE:
I don't want a formula. I would use the format options.
The alfanumeric string must be under the numeric one.
Note the first capital letter.

I tried "mm/dd/yyyy dddd" but it returns

05/13/2004 thursday

(on the same line).

Do you know some tricks to do this?

Thank you, Alex.

Help cell formatting.
 

I don't think you can do this with custom formatting but I have a formula
work around using a second cell. I know you didn't want a formula but
perhaps it'll give you some ideas for playing with the formula. (I tried
inserting char(10) in the custom formating but it didn't work.

Assume the original date is in cell A1. Try this formula in the cell where
you want the two lines to be displayed. Note the alignment on this cell
must be set to Word Wrap. Obviously, you could replace the cell reference
below with whatever formula (if any) is calculating the date.

=TEXT(A1,"mm/dd/yy")&CHAR(10)&TEXT(A1,"dddd")

This would work if all you need to do is display the date and day of week.
If you need to do math with this result, you'll need a different solution or
would have to extract the date from the result.

- John Michl
"Frank Kabel" wrote in message
...
Hi
AFAIK this is not possible using a cell format

--
Regards
Frank Kabel
Frankfurt, Germany


y wrote:
Hi all,

I would format a cell to show informatios as below:

05/13/2004
Thursday

NOTE:
I don't want a formula. I would use the format options.
The alfanumeric string must be under the numeric one.
Note the first capital letter.

I tried "mm/dd/yyyy dddd" but it returns

05/13/2004 thursday

(on the same line).

Do you know some tricks to do this?

Thank you, Alex.