See the attached spreadsheet which does simple addition. Joe
Harold Fuchs wrote:
Joe Conner wrote:Not exactly what you are asking for, but it is a bit along the way:Format the cell as User-defined using " ##' ???/??? " without the quotes.Hope this helps a bit. Harold Fuchs wrote:I'm using OO2.2 on Win XP2.How do I get a column in Calc to display feet and inches as per, for example 3'9" but still be able to do arithmetic on the value, treating this example as 3.75 feet? I don't mind if the inches symbol (") is not shown but the feet symbol (') must show. So far about the best I can do is to have the feet in one column, a quote in the second column and the inches in the third with no border between them and the columns made as narrow as possible. Please tell me there's a better way.--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]That's very neat and does get close; thank you.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)
Enter whole feet in a column. Enter inches in an adjoining column.Use a formula for arithmetic =((cell 1st) + (cell 2nd)/12) with the rest of the arithmetic following.
Fuchs.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
