Forum Discussion
Formatting combined data
Is it possible to format a spreadsheet with multiple data in the cells? I need to create a yearly spreadsheet with the dates written as (example): Monday-02/06/2024. Due to the nature of the spreadsheet, it needs to appear exactly like that. I don't see that listed in the choices for Date Formatting. If its not possible, I will need to copy, paste and edit each cell individually which is kind of tedious. I was hoping there might be a way to conditionally format the whole year in columns. Thank you.
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
- Thank you so much!!
- Quick question: I applied the formatting as listed above but when I try to replicate it to adjoining cells, it just copies the data from original cell instead of formatting it in the requested order; ie Monday, 04/01/2024 (repeats this to additional columns). I don't know if its possible but was hoping I could get a formula where it would automatically go: Monday, 04/01/2024, Tuesday 04/02/2024, Wednesday 04/03/2024 etc. Does that make sense? I am new at using Excel so I really appreciate your help. Thank you.
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....
