G
gerry.lisa
How do I use the custom formatting to get this result?
....Lisa
....Lisa
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
Try custom format as: ddd mmm d
C
Chip Pearson
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)
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)
G
gerry.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)
Thanks Max and Chip...your suggestions gave me:
Mon, January 1
I would like Mon Jan 1
....Lisa
G
gerry.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)
You're right,
ddd mmm d did it.
I had ddd, mmmm d
I had a comma and an extra "m".
Thanks again
....Lisa
D
Dave Peterson
It worked ok for me.
You may want to try it again.
You may want to try it again.
C
Chip Pearson
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)
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)
M
Max
Good to hear you got it up there ..