Show dates the same way
Show every date in column C as mm/dd/yyyy, centered.
Formats, highlights or saves files. Doesn't change your values.
What it does, step by step
- Show C2:C1000 as mm/dd/yyyy
- Center C2:C1000
Use it in MacroRoni: open the Starter gallery, search for "Show dates the same way", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More dates & time macros
Dates & timeAge from date of birthWork out each person's age in years from the birth dates in column B, in column C.Changes data · backup onDates & timeDays until dueCount the days from today until each due date in column C, in column D.Changes data · backup onDates & timeDays overdueShow how many days each due date in column C is late (0 if not late), in column D.Changes data · backup on