I want to use writer to generate a (crude) invoice.
I use simple formulas manipulate the numbers that I type in.
I want to add a dollar sign $ so that my numbers appear as money.
I have tried enclosing the $ in quotes as in:
="$" +
That didn’t work. What’s the trick please?
IMHO Writer is not the adequate tool. If your invoices are really simple, use Calc. Text formatting will be much more simplistic than in Writer but you’ll gain on versatility and power for your operations (addition, multiplication, tax computation, …), not speaking about the range of functions in formulas.
If your invoice layout is relatively sophisticated, use Base which has a report generator. Base takes its input data from a database which can be a Calc spreadsheet. This is the tool of choice to add some “fancy” in your invoices.
Insert a table, choose menu Table - Number Format - Category Currency, and test a bit.
That worked. I’m too old to monkey button push and finding things on my own (mostly).
Now to figure out how to not print $ signs. I’m assuming that editing the currency format for some cells would do it.