I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is nessacery for this data to be displayed in the wrap text style but with custom formating this dosn't work. I summised I needed to enter a line break and following advice I found online I did the following in custom formating: dddd alt0010 dd/mm/yyyy. This displays the data in the correct fashion but for some reason if I attempt to resize the column width the data is undisplayable?!
Have scoured the help topics and internet attempting to find a solution to this but cannot find one. Feel like such a nOOb....
Basically I want the day and date displayed as such:
In one cell I can make compact, I will be making rotas through out the year so it would be convient to have this function available without the need of ardous manual input. Any suggestions are more then welcome!