Display format

Display Format is a cell option available to a number cell type only. Designer can set up a display format for the numbers.

 

Display format is used in KPI values as well.

 

Format patterns with examples:

 

Numbers

Number

Format

Result

10000

0,0.0000

10,000.0000

10000.23

0,0

10

10000.23

+0,0

10

-10000

0,0.0

-10,000.0

10000.1234

0.000

10000.123

10000.1234

0[.]00000

10000.12340

-10000

(0,0.0000)

(10,000.0000)

-0.23

.00

-.23

-0.23

(.00)

(.23)

0.23

0.00000

0.23000

0.23

0.0[0000]

0.23

1230974

0.0a

1.2m

1460

0 a

1 k

-104000

0a

-104k

1

0o

1st

52

0o

52nd

23

0o

23rd

100

0o

100th

 

Currency

Number

Format

String

1000.234

$0,0.00

$1,000.23

1000.2

0,0[.]00 $

1,000.20 $

1001

$ 0,0[.]00

$ 1,001

-1000.234

($0,0)

($1,000)

-1000.234

$0.00

-$1000.23

1230974

($ 0.00 a)

$ 1.23 m

 

Bytes

Number

Format

String

100

0b

100B

2048

0 b

2 KB

7884486213

0.0b

7.3GB

3,46748E+12

0.000 b

3.154 TB

 

Percentage

Number

Format

String

1

0%

100%

0.974878234

0.000%

97.488%

-0.43

0 %

-43%

0.43

(0.000 %)

43.000 %

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk