We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How to have different currencies coexisting?

asked 2017-12-21 10:44:59 +0200

Mark Jeronimus gravatar image

updated 2021-05-27 16:06:33 +0200

Alex Kemp gravatar image

How can I have multiple currencies in a single sheet, where some use comma/period as separators and others use period/comma as separators?

For example, I want to have them look like this:


I'm currently unable to achieve this as the locale setting and Decimal separator setting appears to be global to libreoffice and not even to a single sheet! It seems to me like a bug that when I select a different currency in Format that the separators of that currency are not respected.

edit retag flag offensive close merge delete


That's a property of cell format; and possibly best served as cell style.

Mike Kaganski gravatar imageMike Kaganski ( 2017-12-21 11:07:58 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-02-13 11:03:56 +0200

oliorad22 gravatar image


Question from 3 years ago. This may help:



edit flag offensive delete link more


It doesn't because it doesn't answer the question.

erAck gravatar imageerAck ( 2021-02-13 17:05:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-21 10:44:59 +0200

Seen: 156 times

Last updated: Feb 13