https://bugs.documentfoundation.org/show_bug.cgi?id=158502
--- Comment #9 from ady <[email protected]> --- (In reply to m.a.riosv from comment #8) > (In reply to ady from comment #7) > > As a hint, you might want to try something like (replace NatNum3 with the > > format you are interested): > > > > [NatNum3]"Total:" 10 > > That doesn't work, the result is: I did not provide a solution, just a hint; and I admit I might be completely wrong about it. Using an auxiliary cell with a concatenate formula might help, maybe (or maybe not). I don't know the real requirements for the particular case either. Now, whether any hint and/or potential workarounds work as users need (or not) is not the point of this bug report. The report is about using [NatNumX] (with "X" being a valid number for the format) in some position in the number format other than the initial/start of the code. The answer is that it is not supposed to work in any other position, only at the start of the code. Anything else should be discussed elsewhere, and the report (as presented in comment 0) should be NAB. -- You are receiving this mail because: You are the assignee for the bug.
