Help cell formatting.

  • Thread starter Thread starter y
  • Start date Start date
Y

y

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting date as first letter of day only 33
Formula to display nearest following Thursday in mm/dd/yyyy format 1
Problem with date formatting 5
International Date formatting 4
Dates Format changing when copying data between workbooks 2
Excel is changing date format incorrectly 7
Copy Range to new Range and keep DATE format?? 26
Day of Week from dd/mm/yyyy 7

Back
Top