Brian Barker wrote:
At 18:15 18/06/2007 +0100, Harold Fuchs wrote:
So now I'm going to get picky: how do I *enter* the data in feet and
inches, say 3'5 instead of having to work out the decimal equivalent
of 5 inches which is what we have computers for ;-) ?
Is there some way to get Calc to use a single quote as a decimal
point in just one column? If so, I could enter 3'5 into, say, A1 and
have, say B1 use it as =INT(A1)+10*((A1-INT(A1))/12)
--
Harold Fuchs
No: you cannot do this simply by arranging that the feet symbol is
seen as a fractional point, since 3'1 (three feet, one inch) and 3'10
(three feet, ten inches) would both map to the same value of 3.1 and
thus be ambiguous.
You could use:
=FIND("'";x)
to find the position (p) of the feet symbol in the entered text, and
then:
=VALUE(LEFT(x;p-1))
and:
=VALUE(MID(x;p+1;2))
to strip out the feet and inches parts separately. (The last
parameter of the MID function could be any suitably large number.)
You could then combine these values as you wish.
Note that you will have to be careful over "custom quotes": if you
have this option selected, your feet mark in the entered data will get
replaced by a genuine apostrophe and so need a modified formula. You
may also find that doing some calculations into temporary columns in
which values are differently expressed or formatted helps; such
columns could be hidden or simply not printed, of course.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
It does. Thanks.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
