Ask Your Question

How Do I Change A Libre Calc Template Value From £ to $?

asked 2020-09-16 00:47:44 +0200

crevice gravatar image

I want to use this 3 page template for creating a budget but it is not setup for $. How do I simply change it from £ to $?

Thank you

edit retag flag offensive close merge delete



It is a bizarre template, maybe because it has been saved from Excel. Language is English USA but everything in £, and not currency but special format. I see the problem, many of the totals won't change to $ by just changing the format. It might be the remnant of conditional formatting in Excel. Copying the formula in the address bar (press Esc or Enter), deleting the cell (sometimes press twice to delete) then pasting the formula back in works. Sometimes, deleting doesn't work and dragging down from the cell above overwrites the sticky format. Maybe someone cleverer than me knows a quicker way,

When everything is changed to $ and to your language, save it as template or you will have the same trouble in future.

Earnest Al gravatar imageEarnest Al ( 2020-09-16 10:55:56 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-09-16 07:07:54 +0200

newbie-02 gravatar image

hello @ crevice,

plenty of options, depends on your 'locale', 'language' and 'default currency' settings [tools - options - language], note down what you change to have possibility to revert,

direct solution without experimenting: [ctrl-1 - numbers tab], edit the formatting description in the bottom line from £ to $, both or all three appearances, they are for '+', '-' and '0' values, it creates an additional format which you can apply to other cell by clicking ...

P.S. 'solved marks' and 'likes' welcome,
click the grey circled hook - ✓ - top left to the answer to turn it green if the problem is solved,
click the "^" above it if you 'like' the answer,
"v" if you don't,
do not! use 'answer' to add info to your question, either edit the question or add a comment,
'answer' only if you found a solution yourself ...

edit flag offensive delete link more

answered 2020-09-16 17:41:41 +0200

crevice gravatar image

updated 2020-09-16 18:59:17 +0200

OK, I think I've fixed everything. I selected all of the cells and set the currency but it still did not change the appearance of all cells. I'm not sure why but when I simply placed a number in the cell then went to a new cell it changed to $.

Anyway here are links to that monthly budget template corrected and to an annual budget template that has the same type appearance that I will be using as well.

edit flag offensive delete link more


Slight corrections made to monthly.

crevice gravatar imagecrevice ( 2020-09-16 18:40:09 +0200 )edit

slight changes

crevice gravatar imagecrevice ( 2020-09-16 18:59:37 +0200 )edit

it's a very old issue with calc cells, values and formatting,
intentionally - as wrong as i like it, but it's heavily defended by the developers - some formatting changes, e.g. from text to number and v/v, are NOT! evaluated when you apply the formatting, but when you key in the next input,
it's producing lot's of problems for plenty people, but it's 'calc-style',
'idea' is to keep user 'save' against unwanted changes, problem is that theese unwanted changes appear later when nobody understands why and undo is far away, the program is 'not obeying' what the user wants, and it's quite difficult to correct bigger amounts of data ...
if you share my doubts that this makes sense ... try to convince @Mike Kaganski ... ;-)
happy hacking ...

newbie-02 gravatar imagenewbie-02 ( 2020-09-16 19:23:49 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-09-16 00:47:44 +0200

Seen: 30 times

Last updated: Sep 16