Just discovered Excel works in eighths and sixteenths…
0 reactions
Just discovered Excel works in eighths and sixteenths! Geeks celebrate!
I will sometimes use excel to calculate "I need to divide this into 3 equal chunks". I convert things to decimal (ie 24.5 inches), then divide by 3, then try and convert the resulting decimal back to eighths or sixteenths. (ie in this case what is 8.166666)
Anyway i was working on something today, and happened to type a fraction like 3 3/8, and it kept that format and any equation i did after that used the fraction. Turns out if you use "Format Cells" and select "Fractions" you can choose to do everything in "Eighths" or "Sixteenths".
What!?
So excited i don't have to keep trying to convert the decimals back or yelling to Alexa "How many 32nds is .1592!
I hope i'm not the only one that does this...There's got to be other Geek woodworkers out there too? Okay - going back into my shell now.... :-)
https://preview.redd.it/iaxuhcmt8ylg1.png?width=1328&format=png&auto=webp&s=d4b2daf9549ececb7994d88d81af9a2442ebc9f1
(I know..or just change to metric already!)
#diy
source
I will sometimes use excel to calculate "I need to divide this into 3 equal chunks". I convert things to decimal (ie 24.5 inches), then divide by 3, then try and convert the resulting decimal back to eighths or sixteenths. (ie in this case what is 8.166666)
Anyway i was working on something today, and happened to type a fraction like 3 3/8, and it kept that format and any equation i did after that used the fraction. Turns out if you use "Format Cells" and select "Fractions" you can choose to do everything in "Eighths" or "Sixteenths".
What!?
So excited i don't have to keep trying to convert the decimals back or yelling to Alexa "How many 32nds is .1592!
I hope i'm not the only one that does this...There's got to be other Geek woodworkers out there too? Okay - going back into my shell now.... :-)
https://preview.redd.it/iaxuhcmt8ylg1.png?width=1328&format=png&auto=webp&s=d4b2daf9549ececb7994d88d81af9a2442ebc9f1
(I know..or just change to metric already!)
#diy
source
| 4,000 mlx | |
| 5 | |
| 0 |