Ask Your Question

When everything is changed to $and to your language, save it as template or you will have the same trouble in future. ( 2020-09-16 10:55:56 +0200 )edit 2 Answers Sort by » oldest newest most voted 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 ...

more

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.

more

Comments

Slight corrections made to monthly.

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

slight changes

( 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 ...

( 2020-09-16 19:23:49 +0200 )edit

Stats

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

Seen: 30 times

Last updated: Sep 16