gsphelp  Format

<< Click to Display Table of Contents >>

Navigation:  GSP environment > Simulation Results > Output tables > Calculated columns >

gsphelp  Format

 Previous pageReturn to chapter overviewNext page

The format string is constructed by using a 0 (zero) for compulsory digits, and a # (hash) for optional digits.

 

The following table shows some sample formats and the results produced when the formats are applied to different values:

 

Format string

1234

-1234

0.5

0

0.531






(none)

1234

-1234

0.5

0

0.531

0

1234

-1234

1

0

1

0.#

1234

-1234

0.5

0

0.5

0.0#

1234.0

-1234.0

0.5

0.0

0.53

0.0##

1234.0

-1234.0

0.5

0.0

0.531

0.00

1234.00

-1234.00

0.50

0.00

0.53

#.##

1234

-1234

.5

0.53

#,##0.00

1,234.00

-1,234.00

0.50

0.00

0.53

#,##0.00;(#,##0.00)

1,234.00

(1,234.00)

0.50

0.00

0.53

#,##0.00;;Zero

1,234.00

-1,234.00

0.50

Zero

0.53

0.000E+00

1.234E+3

-1.234E+3

5.000E-01

0.000E+00

5.310E-01

#.###E-0

1.234E3

-1.234E3

5E-1

0E0

5.31E-1