Ask Your Question

Revision history [back]

What is the difference between two currency formats?

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?