Ask Your Question

how to convert decimal to fraction

asked 2019-05-16 20:51:22 +0200

Dr Dick gravatar image

I am using fractions of inch in woodworking project and the formula option gives me decimal numbers

edit retag flag offensive close merge delete


I don't know the answer to your question, but I expect that part of the solution would involve telling Calc that you want calculations done to the nearest eigtth of an inch, or sixteenth, or thirty-second, or sixty-fourth. Perhaps not so easy. In the meantime, you could construct a chart like the following to help : 1/32 0.03125

1/16 0.0625

3/32 0.09375

1/8 0.125

5/32 0.15625

3/16 0.1875

7/32 0.21875

1/4 0.25

9/32 0.28125

5/16 0.3125

11/32 0.34375

3/8 0.375

13/32 0.40625

7/16 0.4375

15/32 0.46875

1/2 0.5

and use it to "convert" the Calc decimal results back into convenient fractions for your own use. (Soirry, I stopped at half an inch.)

ve3oat gravatar imageve3oat ( 2019-05-16 21:19:15 +0200 )edit

Turn everything to millimeters, the problems are over.

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-05-16 21:51:20 +0200 )edit

Perhaps the Questionner's tools are all calibrated in inches (ruler, square, calipers, drill bits, mitre box, etc). Perhaps he is repairing or refurbishing cabinetry that was made in inches.

ve3oat gravatar imageve3oat ( 2019-05-17 03:28:09 +0200 )edit

This means OP's problem is an integer one. He's working only with multiples of 1/32" or 1/64". He could transform his spreadsheet to use only whole numbers. The the sheet structure would be: an entry area to transform input usual units, like 5/32 into an integer number, the computation area and a display area where the result is converted back into common units.

ajlittoz gravatar imageajlittoz ( 2019-05-17 08:16:59 +0200 )edit

What kind of input? What's "the formula"? What kind of fractions (accepted denominators, mixed or not) would you like to get displayed?

As long as your results actually are numbers (instead of text looking like numbers) this is a matter of formatting.

Lupp gravatar imageLupp ( 2019-05-17 16:50:16 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-05-17 14:16:09 +0200

erAck gravatar image

Format the cells with a Fraction number format. Under Format -> Cells... (or Ctrl+1), tab Numbers choose Category Fraction and from Format pick a suiting one like # ?/4 or # ?/8

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-16 20:51:22 +0200

Seen: 52 times

Last updated: May 17