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
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!!