How do I convert decimal inches to fractions in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Why not just Format>Cells>Number tab>Fractions, "up to two digits"?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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!
 
Back
Top