Version: 24.2.5.2 (X86_64).
With a formula in the cell too, the character spacing never seems to stick at all.
Version: 24.2.5.2 (X86_64).
With a formula in the cell too, the character spacing never seems to stick at all.
All spreadsheet applications align numbers at the right cell margin. If your sequence of digits is really meant to be a decimal number, you can enforce left alignment. If your sequence is meant to be a phone number, zip code, article number or any other kind of identifier, format the cells as text before digits. Text cells have no numeric value. Entered text is taken literally.
Convert existing numbers to text:
.+
&
Sorry, I clarified my question. I don’t think your answer has anything to do with what I’m asking.
A formula returning text returns one string. You can not format any substrings of formula results.
You are free to report this as a request for enhancement. I would rather remove the formatting of the displayed formula string which raises wrong expectations.
I guess the following was meant for this thread:
You should report a feature request, not a bug; and the request must be not to allow formatting selection with formulas, but to enable the sidebar’s Set Character Spacing
control when you are not in the cell editing mode (and - what is the same thing - to enable Format
→ Character
in that mode). Because it’s not clear why this formatting can’t apply to the whole cell, which would allow to work fine with formulas.