i.e., number prefixed with minus. If any number starts with (zero), Calc will drop the leading zero. Figure . Entering data .
. . Entering Text: Unlike numbers, any character can be entered as data in Calc. Entered text will be aligned to the left side within the cell by default.
When you enter any numeric value, if it is aligned left, it is understood that the entered content is not a number. If there is any number that starts with a single quote, Calc converts that number to text (Refer Figure . ). Figure .
Entering Text . . . Entering Date and Time: Before entering date, ensure the format of your system date.
Calc accepts date as per the system date format. If your system has American date format i.e. month-date-year; you should enter dates in Calc spreadsheet as mm/dd/yy. If your system follows the Indian date format, date should be entered as dd/ mm/yy form in Calc.
For example: if your system has American Date format, 18th December should be entered as . As soon as the date is typed in the correct form, the entered date will be aligned on the right side within the cell, and if you place the cell pointer in that cell, the formula bar shows your date as “ ” (Figure . ). This is a visual clue to know whether the date is accepted or not.
A Date format can be changed to any other valid form using “Cell Formatting” dialog box and it will be discussed later. Figure . Entering Date Like dates, for entering time, Calc follows the general format HH:MM:SS, where HH, MM and SS represent hours, minutes and seconds respectively. Different Date Formats Order styles Countries DD/MM/YYYY Asia (Central, SE, West), Australia, New Zealand, parts of Europe, Latin America, North Africa, India, Indonesia, Bangladesh and Russia YYYY/MM/DD Bhutan, Canada, China, Koreas, Taiwan, Hungary, Iran, Japan, Lithuania, Mongolia.
MM/DD/YYYY United States, Federated States of Micronesia, Marshall Islands DD/MM/YYYY and MM/DD/YYYY Malaysia, Nigeria, Philippines, Saudi Arabia, Somalia DD/MM/YYYY and YYYY/MM/DD Afghanistan, Albania, Austria, Czech Republic, Germany, Kenya, Macau, Maldives, Montenegro, Namibia, Nepal,