How do I convert decimal inches to fractions in excel

J

JTZ

Have reports from Cad/Cam "CadCode" with mesurements in decimal inches.
would like to convert to fractions ( 1/2",1/4",3/32" ect..) Have formula for
1 cell at a time but whole row ( or whole document) would be quicker
 
N

Niek Otten

Why not just Format>Cells>Number tab>Fractions, "up to two digits"?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
S

swatsp0p

Did you know that YOU can make this change??!!!

Simply right click anywhere on the toolbar and click Customize.

then, right click on the desired button and choose Edit Button Image...

Change colors to your heart's content!!

Good Luck!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert decimal to inch & fraction 1
Help with formula (decimal to fraction) 2
Fraction to Decimal 2
show fractions rounded up to nearest 1/16th inch 16
How to format feet/inches (ft'in") 4
How do I convert a fraction to its true decimal, not a date no. 2
Display a number in feet inches and fractions of and inch 1
change decimal to feet and inches 10

Top