Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |