Sharp Zaurus SL-5500 Software Manual page 33

ꋯ Text Prefix
Prefix
'
"
^
• Entering Calculating formulas
Formulas are calculations using the cell data and are input similar to general
math calculations. To input a formula in HancomMobileSheet, you must start
with the equal sign[=]. There are two ways to write formulas. One is to directly
input the data, such as '3+4', into the cell. The other is to use the cell
number, such as 'A1+B1'. When the value of the cell number is changed, the
result value also changes automatically. This reduces time and effort.
• Entering Numbers into formulas
In entering numbers into calculating formulas, numbers 0~9 can be used.
Commas, parentheses and currency symbols cannot be used together with
numbers in a calculation formula. Negative numbers are indicated with a [-] in
front of the number.
• Entering Letters into formulas
For entering letters into calculating formulas, input the quotation mark["]. For
example if you input ="year 2000" then the letters 'year 2000' can be used
together with the formula sign [=]. Letters used in functions can also be used
with quotation marks in a formula.
• Entering Dates
If the date or time is input according to the formats that are designated in
HancomMobileSheet, they will always follow one of those formats. Dates use
the slash [/] or dash [-]. For example, August 1, 2000 could be done as
08/01/2000.
• Entering Time
You can either use a 12 or 24-hour format for inputting time. A time value is
distinguished by virtue of the colon [:] in the data. For using a 12 hour clock
CHAPTER 3:
Result
Left 'Text
Right "Text
Center ^Text
HancomMobileSheet
Input
Text
33
Result
Text
Text