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

Ask Your Question

Default currency per worksheet

asked 2020-03-19 21:21:26 +0200

Mateusz L gravatar image

Is there such a feature in LibreOffice Calc: Default currency for all money cells in Worksheet?

If yes, then:

A) how to set default currency for cells with money format?

If no then:

B) could you add this functionality to software?


Many people work in international companies, where some reports should be with different currency. Sometimes there is only one currency per sheet. It gets quite long time to set appropriate currency format for all cells in worksheet.

edit retag flag offensive close merge delete


Direct formatting is evil - with very few exceptions.

Lupp gravatar imageLupp ( 2020-03-20 00:38:13 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-03-19 21:49:42 +0200

ebot gravatar image

updated 2020-03-19 21:55:36 +0200

You can e.g. select a column or an entire spreadsheet.

Then choose Format > Cells...

image description

In the "Format Cells" dialog box, select Currency and the desired format (e.g. "USD $ English (USA)" or others.

image description

Is that what you are looking for?


Once you've formatted a spreadsheet, you can save it as a document template. When you open the document template you always have your settings.


If my answer has solved your problem, please click on the checkmark in the circle Bildbeschreibung to the left of the answer for upvote. This will tell the community that the question has been answered correctly.

edit flag offensive delete link more


With me Windows 10 Home; Version 1909; 64-Bit | LibreOffice, Version: (x64).

ebot gravatar imageebot ( 2020-03-19 21:50:01 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-03-19 21:21:26 +0200

Seen: 79 times

Last updated: Mar 19 '20