Ask Your Question

What is the difference between two currency formats?

asked 2016-05-02 17:39:20 +0100

AnitMadC gravatar image

In Format Number (found by clicking the Table menu, then Number Format) under the currency category there are two formats that are almost identical. The Format code box shows the difference between the two. Here is what is displayed in the Format code text box for each:

  • [$$-409]#,##0;-[$$-409]#,##0
  • [$$-409]* #,##0;-[$$-409]* #,##0

What is the difference between the two? What is the purpose of the asterisks?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-05-02 18:33:18 +0100

erAck gravatar image

The format with asterisk is only relevant in Calc spreadsheets, Writer tables don't support it (yet?). In Calc the currency symbol ($) would be left aligned in a cell, the value right aligned. The asterisk means "fill between with the following character" (here space).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-05-02 17:39:20 +0100

Seen: 41 times

Last updated: May 02 '16