Reference Guide

Formatting numbers and dates206
Characters for formatting cells displaying date and time data
Data Type Character Displays Example
Day
d The number of the day in the
month with no leading
zeros. If the date for day is
less than two characters, the
date displays without a zero
before it.
The first day of a
month with the
format:
d gives ‘1’
dd The number of the day with
leading zeros. If the date for
day is less than two
characters, the date displays
with a zero before it.
The first day of a
month with the
format:
dd gives ‘01’
ddd The name of the day
abbreviated. The first letter is
capitalized.
‘Monday’ with the
format:
ddd gives ‘Mon’
dddd The name of the day in full.
The first letter is capitalized.
‘Monday’ with the
format:
dddd gives
‘Monday’
dddd dd The day of the week
followed by a space and the
number of the day.
‘Monday’ with the
format:
dddd dd gives
‘Monday 01’
Month
M The number of the month
with no leading zeros. If the
number for month is less
than two characters, the
number displays without a
zero before it.
‘January’ with the
format:
M gives ‘1’