Cell numeric format

You use this option to change the numeric format of the numbers in the data area:

In the dialog is shown a list of the numeric format ready to use an a Custom section to write a personalized format. The formats ready to use are:

Format Description 12345.67 -12345.67
--- Uses cube default format 12346 -12345
0 None 12346 -12345
0.00 Two decimal digits 12345.67 -12345.67
#,##0 Coma separator in thousands 12,346 -12,345
(#,##0) Negative parenthesis 12,346 (12,345)
#,##0.00 12,345.67 -12,345.67
(#,##0.00) 12,345.67 (12,345.67)
$#,##0 Dollar or money sign (as established by windows) $12,346 -$12,345
($#,##0) $12,346 ($12,345)
$#,##0.00 $12,345,67 -$12,345.67
($#,##0.00) $12,345.67 ($12,345.67)
Percentage Percentages format. The number gets multiplies by 100 (%) .074
0% None 7%
00% Cero justified 07%
0.00% Two decimal digits 7.40%
00.00% 07.40%
Format in thousands Formats showing information in thousands (,.) 12345.67
#,##0,. Number divided by 1000 12. -12.
(#,##0,.) 12. (12.)
#,##0,.00 12.35 -12.34
(#,##0,.00) 12.35 (12.34)

The Custom format lets you establish the format that you want. You can use the characters #, 0, $, (), ,, ., ,., % to create new formats. You also can experiment with other characters.

To change the numeric format, click the format you want to use.