Format Formulas - Brother GeoBook NB-80C Instructions Manual

Format Formulas
When you enter a date or time value as a formula, Spreadsheet initially
displays a number;, however, you can change the format to suit your needs.
The following table shows the available date and time formats:
Use the same
procedure to
change date and
time formats that
you use to
change number
formats.
Format
Date : Long
Date
Date
Date : Long,
Date : Long,
Date : Long,
Weekday
Date : Short
Date : Short, Zero Padded
Date : Long, Month & Day
Date : Long, Month & Day,
No Weekday
: Short, Month & Day
: Long, Month & Year
Condensed
No Weekday
Condensed, No
i Example
23456 = Saturday, March 21st,
1964
23456 = Sat, March 21st, 1964
23456 = March 21st, 1964
23456 = Mar 21st, 1964
23456 = 3/21/64
23456 = 03/21/64
23456 = Saturday, March 21st
23456 = March 21st
23456 = 3/21
23456 = March 1964
Date : Short, Month & Year
Date : Year _"
Date : Month
Date : Day
Date : Weekday
Time : Hour MiD Sec
Time : Hour MiD
Time : Hour
Time : MiD Sec
23456 = 3/64
23456 = 1964
23456 = March
23456 = 21st
23456 = Saturday
1234.567 = 2:36:29PM
1234.567 = 2:36PM
1234,567 = 2 PM
1234.567 = 36:29
)_ To change the format for dates or times:
1. Select the cell(s) containing the value(s) whose format you want to
change.
2. Select Number Format from the Properties menu. The Number Format
dialog box appears.
3.
.
5.
Select the format you want from the Formats list. An example of the format
appears in the dialog box.
Click on Apply. Spreadsheet changes the format of the selected cell(s).
Click on Close. The dialog box disappears.
Spreadsheet 77