Hi,
I need a couple years of dates, vertically and sequentially. I made a list using drag and drop and modified how it displays so it more readable
- As you can see in formula bar + the top cell the date format is “DD/MM/YYYY”
- Using “Format Cells” > Numbers > Format Code" I used a user defined code to make it display: “WW¬ NNN, DMMM”
This lets me refer dates easily using the 1st format but in daily life it displays a friendly format
—>>> I wonder if I can modify some of the displayed text. So for example make the first number Italic or make that font size smaller.
→ If I double click the cell it lets me edit the cell content which is like “DD/MM/YYYY” instead of the fancy display format/text
→ If I right-click the cell > “Format Cells…”, again I can only change the whole cells style, not only part of that text
I know I could make a new column on the left side, and have that of small width just enough to accomodate 2 numbers but I would prefer to have it all in the same cells/columns.