Forum Discussion
Solved
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 spreadsh...
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
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....
- 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)?- I am sorry but I don't understand your reply. Did you attach something?