formatting a date to look like Wed Jan 3

  • Thread starter Thread starter gerry.lisa
  • Start date Start date
G

gerry.lisa

How do I use the custom formatting to get this result?

....Lisa
 
Lisa,

Use a custom number format of

ddd mmm d


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
Chip said:
Lisa,

Use a custom number format of

ddd mmm d


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
Click to expand...

Thanks Max and Chip...your suggestions gave me:

Mon, January 1

I would like Mon Jan 1

....Lisa
 
Chip said:
Lisa,

Use a custom number format of

ddd mmm d


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
Click to expand...

You're right,

ddd mmm d did it.
I had ddd, mmmm d
I had a comma and an extra "m".
Thanks again

....Lisa
 
I can't replicate that. I tested the format "ddd mmm d" in both Excel 97 and
Excel 2007, and both displayed the string "Mon Jan 1". Are you user you have
3, not 4, 'm' characters for the month. 'mmmm' will return the full name of
the month. 'mmm' returns the 3-character month abreviation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
You must log in or register to reply here.

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

Date format question 3
Excel Help with dates 2
SUMPRODUCT where between 2 dates 3
Default date format 4
formating date from general2 custom 6
Formatting and modelling 2
series of dates, step by 1, Mon-Thurs only, for 2007 2
how do I add 2.5 hours to a column of data 3

Back
Top