Page 10 - Document Preparation Guidelines - Excel

F I NA NC E R EF ER EN C E G U ID E

Dates

Cells with dates should be formatted as follows:

• Category: Date
• Type: m/d/yyyy
• Column alignment: Right (formatting the cell as date will by default right align the date)

Alternatively, a document may be more visually appealing if a row of dates are formatted with a two-digit month and two-
digit date, such that all dates are the same length. If that is more visually appealing, use a Custom category to format dates as
mm/dd/yyyy (leading zeroes will display for single-digit months and dates). Since all dates will be the same length, it may also
be more visually appealing to center the column heading and all of the dates.

EMORY ADVANCEMENT AND ALUMNI ENGAGEMENT | FINANCE REFERENCE GUIDE | Updated 11.7.21 9