LibreCalc how to edit only part of a cells formatted displayed text (Format Code)

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 :slight_smile:

image

  • 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 :slight_smile:

—>>> 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.

Partial formatting only available for the constant strings, and for the manual (direct) formatting method.
There is no any way to format partially a formatted NUMBER.

1 Like