Calcapp has long had comprehensive support for formatting
numbers. Use thousands separators (*200 000*, not *200000*),
format numbers using scientific notation (*1.00E+04*, not *10000*) and format
the fractional part of a number as an actual fraction (*3 3/4*, not *3.75*). You
also get full control over the number of decimal places that are used (*12.36*
can be formatted as *12.4* or as *12.3600*, depending on your preferences).

What hasn’t been very straight-forward in the past has been formatting numbers
with leading zeroes. Imagine if you always want a number to appear formatted
with four digits at a minimum. That means that *23* should appear as *0023*,
*123* as *0123* and *12345* as *12345*. Now, you can specify the number of
integer digits a number should be formatted with, right in the inspector:

## Bonus tip: Adding leading zeroes the old-fashioned way

App creators have happily been creating fields with leading zeroes even without
this feature, thanks to the flexibility afforded by Calcapp’s formulas. Here’s a
now-redundant formula for formatting the value of *Field1* with leading zeroes
so that it always consists of at least four digits:

This formula first checks to see if the value of *Field1* is defined and not
blank. Then, it calculates the length of the formatted value of *Field1* using
the LEN function and subtracts the length from four, thereby calculating the
number of leading zeroes.

In other words, if the value is 23, two leading zeroes are used. If, however, the value is 12345, no leading zeroes should be used. The MAX function is used to ensure that the number of leading zeroes is never negative.

Finally, a single zero is repeated the correct number of times using the REPT
function, invoked with the text string “0” (producing “00” if *Field1* is 23).
That text string is then joined together with the actual value using the **&**
operator, finally producing a text string such as “0023”.

**Note:** The eagle-eyed reader may have noticed that we only pass two
parameters to the IF function in the formula above. Traditionally, the IF
function takes three parameters: a condition which evaluates to TRUE or FALSE, a
value to use if the condition evaluates to TRUE and a value to use if it
evaluates to FALSE. It turns out that popular spreadsheets also accept only two
parameters as well, allowing users to leave out the third parameter, which
created work for some of our app creators. As a result, we have made the third
parameter optional in Calcapp. IF now returns a blank value if the condition
evaluates to FALSE and no third parameter is supplied. `IF(2 > 3, 42)`

is thus
now equivalent to `IF(2 > 3, 42, BLANK())`

.