Forum Discussion
Formatting combined data
Birdiedahlby11 Select the cells with the dates.
Select 'More Number Formats...' from the 'Number Format' dropdown on the Home tab of the ribbon.
Select Custom in the Category list.
Enter the following in the Type box, then click OK.
dddd-mm/dd/yyyy
or if you use European d/m/y format:
dddd-dd/mm/yyyy
Birdiedahlby11 Select the cells with the dates.
Select 'More Number Formats...' from the 'Number Format' dropdown on the Home tab of the ribbon.
Select Custom in the Category list.
Enter the following in the Type box, then click OK.
dddd-mm/dd/yyyy
or if you use European d/m/y format:
dddd-dd/mm/yyyy
No formula required. With your 1st formatted date in A1 below:
- Move your mouse to the bottom right corner of cell A1 until you see a cross (+)
- Right-click and Hold the click
- Drag it to B1, C1, D1....
- Thank you. I tried that but it just copies the data and adds a year to it (Monday-04/01/24, Monday-04/01/2025, Monday-04/01/2026). I have been googling help but not sure what to do. I tried putting a sequence but that doesn't work either. Maybe its because I am using only one column for my date information and trying to create a formula or sequence in the column next to it??
- Quite strange as this works no problem here...
You want to create a sequence, OK but what version of Excel do you run (formatting sequenced cells will be required)?
