Date Format

Forums: Microsoft Excel
Email this Topic • Print this Page

When I write today's date (August 22, 2016), Excel changes it to 22-Aug-16.

How can I keep it my way?

Topic Stats
Top Replies
Link to this Topic

Type: Question • Score: 0 • Views: 567 • Replies: 4

No top replies

@gollum,

Right click on the cell, select FORMAT, select the DATE option if it doesn't default to that and select the format you want.

0 Replies

Select Format Cells, choose Custom and in the box type (note the spaces)

dd mmmm yyyy

This would produce 2 digit day numbers, I mean 01 to 09 for the numbers less than 10. If you was single digits for those numbers use d mmmm yyyy

Day codes

d 1 to 31
dd 01 to 31
ddd Sun to Sat
dddd Sunday to Saturday

Month codes

m 1 to 12
mm 01 to 12
mmm Jan to Dec
mmmm January to December

Year codes

yy 16
yyyy 2016

1 Reply

The full list

Code:

m 	Month number without a leading zero 	1

mm 	Month number with a leading zero 	01

mmm 	Month name, short form 	Jan

mmmm 	Month name, full form 	January

mmmmm 	Month as the first letter 	J (stands for January, June and July)

d 	Day number without a leading zero 	1

dd 	Day number with a leading zero 	01

ddd 	Day of the week, short form 	Mon

dddd 	Day of the week, full form 	Monday

yy 	Year (last 2 digits) 	05

yyyy 	Year (4 digits) 	2005

You can add punctuation, dashes etc so

dddd, mmmm dd, yyyy gives a date like Tuesday, August 23, 2016

0 Replies

@contrex,

Thank you.

0 Replies

Date Format

Related Topics

Quick Links

My Account

able2know