Ask Your Question

you provide a leading zero. how about an option to replace trailing decimal zeros with spaces [closed]

asked 2013-11-28 20:45:57 +0100

keng gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 16:30:04.087063

1 Answer

Sort by » oldest newest most voted

answered 2013-11-29 00:48:25 +0100

m.a.riosv gravatar image

Use # instead of 0.

edit flag offensive delete link more


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???

keng gravatar imagekeng ( 2013-12-12 22:50:51 +0100 )edit

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?

keng gravatar imagekeng ( 2013-12-13 00:04:45 +0100 )edit

Question Tools

1 follower


Asked: 2013-11-28 20:45:57 +0100

Seen: 467 times

Last updated: Dec 13 '13