you provide a leading zero option. how about an option to replace trailing decimal zero(s) with space(s)? thus with number format decimal = 4
111
.2
.03
.0004
I wouldn’t be upset with 111.
Edited by LeroyG to add format.
Use # instead of 0.
thank you but:
all that does is insert a # within a cell. I’m trying to create cells like this:
111 and not 111.0000
.2 not .2000
.03 not .0300
.0004 = .0004
since this looks like a feature request, should I be using bugzilla???
I tried number format #.#### which dropped trailing zeros but then right justified the cells. when I tried “justified” LO appeared to left justify the cells. I would think that justification of a number format should provide decimal alignment.
come to think of it, you appear to remove cr/lf (paragraph) characters which just confuses the reader as it would clearly show my issue.
should I be using bugzilla for either of these issues?
As Number Format Codes explains under “Decimal Places and Significant Digits”:
?Displays space characters instead of extra zeros.
One should take into account that having spaces does not automatically make them aligned in cells, because by default, variable-width fonts are used; so in combination with #.???? format code, one needs to use a cell style with fixed-width font (and right-align numbers).
See also this Q&A.