Manual

Changing the Number Format for Values
When you enter a value, Spreadsheet automatically shows it in a standard
format; however, you can change the format to suit your needs. The
following table shows the available formats for values:
Format
General
Fixed (2 decimal places)
Fixed with Commas
Fixed Integer (rounded to a
whole number)
Currency
Currency with Commas
]Currency Integer (rounded to
nearest dollar)
iPercentage (times 100)
Percentage Integer (times 100,
irounded to whole percent)
Thousan-ds- (divided-by 1000 and _
irounded)
Millions (divided by one million
iand rounded)
Scientific
You Type...
1234567
123.4567
1234.567
1234.567
1234.567
1234.56
1234.567
.085
.4275
1234567
Spreadsheet
Displays
1234567
123.46
1,234.57
1235
$1234.57
$1,234.57
$1235
8.50%
43%
1234.57
123456789 123.46
1234.5678 1.23E+03
Spreadsheet 74