Kenn Goutal wrote:
Boy, I'm having a bad (extended) day! Sorry ...
I want to use the TEXT function in Calc.
So:
I left-click on the cell I want to use.
The formula/value (?) bar comes up empty.
I left-click on the that is to the right of the Sigma and to the left
of the value field.
An equals sign appears at the beginning (left-most end) of the value
field.
I left-click on the f(x) "button".
The function wizard comes up.
I double-left-click on the TEXT function in the "Function" selector
field.
The dialog for the TEXT function appears in the right-hand portion of
the box.
There are two arguments.
I left-click in the "number" field,
and then left-click on the cell whose contents I want to format.
I left-click on the "Format" field,
and then I am lost ... ... ...
What sort of string do I put in there?
Should the string be quoted, or not?
What sort of things go in the string,
to cause digits, letters, and/or literal punctuation to come out in
the result?
Thanks again.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
The first argument is a number or reference to a number. The second is a
format string specifying how you want the number formatted. Because the
first is a number, it does *not* want quotes. Because the second is a
string, it does unless it's the name/reference of/to a cell containing a
format string. For details about format strings, see the Help under
"Format Codes".
Also, I wouldn't bother with the long convoluted entry mechanism you
described. Instead in the cell you want, enter =TEXT(number;format_string)
The separator between arguments is the semicolon. The word TEXT may be
in lower case.
So for example, in D7 you could have the formula =text(c3;"# ???/???")
which would display C3 value 5.75 as 5 3/4 or 6.3 as 6 3/10 in D7
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
