Ask Your Question

Calc: Why can I not use both prefix-text and suffix-text in a user-defined format?

asked 2020-12-05 17:51:56 +0100

PaulG gravatar image

I can format a numeric field as "X" #.0 I can format a numeric field as #.0 "Z"

But I cannot format the field as "X" #.0 "Z"

With the latter format the field is always displayed with ###

This is with Calc

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-12-05 18:07:18 +0100

Opaque gravatar image

updated 2020-12-05 18:48:19 +0100


you can set a pre- and postfix, but the content to be displayed may become too wide for the cell.
see also: Error Codes in LibreOffice Calc

image description

Solution: Set a larger column width using Format -> Columns -> Width ... (or just drag the column wider)

Hope that helps

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-12-05 17:51:56 +0100

Seen: 21 times

Last updated: Dec 05 '20