Brother International PDP350CJ Owner's Manual - English - Page 162

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. FDDDDDDDDDDDDDDDTTTT Oiiii aaaaaaaaaaaaaaammmm tttttttttttttttReeeeeeeeeeeeeee eeeeM MALSL SSLLLSDLYLWHHHM ohohhooohooTeoa eoooinnonnnoononaNy nneuuurgrgrrgggrgg oktttttrrr S,,,,,h,,,d eCMMMMMCWNMMZ acoo eoyioooieoonn nnrennnnn oWddkSttt tthhhehhe dPeen nceaa sksyd eeddDDY DYdd aeeeaa,a ydaayy yNrr o W e e k d a y EÑÑ2ÑÑ2ÑÑ2ÑÑ2ÑÑ2ÑÑ2Ñ2ÑÑÑÑÑ2ÑÑ2ÑÑ2ÑÑ2ÑÑ2ÑÑ2ÑÑ2ÑÑ2ÑÑ1ÑÑ1ÑÑ1ÑÑ1 3333333333333332222X 4444444444444443333 A5555555555555554444 M666666666666666 5555 6666======P 7777L SSSMMM2MSM33310 E====aaaa1///93 aaaaattt262t s6/uuurr,22r2rr3t 14124cccc:r:rr6 M/1233hhPhhddd 6/1662aM aaa4622,1:9 ryyy24P119 1,,29Ms s69MM1Ptt 46 Ma4a 11rr 9c9c 6hh6 44 22 11 s st t 1 9 6 4 You use the same procedure to change date formats that you use to change number formats. "To change the format for dates: 1. Select the cell(s) containing the value(s) whose format you want to change. 2. Choose Number Format from the Properties menu. A dialog box appears. Choose a format here. Spreadsheet displays an example of the selected format here. Spreadsheet 148