Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
14 Cards in this Set
- Front
- Back
|
0
|
All numbers are displayed with zero decimal places.
|
|
|
0.00
|
All numbers are displayed with 2 decimal places.
|
|
|
#,##
|
Commas will be inserted to seperate thousands in a number. The # symbol acts as a placeholder.
|
|
|
-
|
The minus sign will be displayed in front of all negative numbers.
|
|
|
$
|
The dollar sign will be displayed in a cell. Other currency symbols can also abe used. Symbols can be placed at the beginning or end of code.
|
|
|
(Red)
|
The number will be displayed in red.
|
|
|
_)
|
Indicates an extra space is added in a positive number to make it align correctly with the negative numbers in the same column.
|
|
|
()
|
Brackets will be displayed around the number.
|
|
|
0.00_);(0.00)
|
Two decimal places.`
|
|
|
mmm
|
Displays the month as text (ie. Jan)
|
|
|
yy
|
The last two digits in the year (ie. 2001 displays as 01)
|
|
|
yyyy
|
The complete year.
|
|
|
mm
|
Displays the minutes.
|
|
|
ss
|
Displays the seconds.
|
