How do I convert decimal inches to fractions in excel
 

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 FormatCellsNumber tabFractions, "up to two digits"?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"JTZ" wrote in message
...
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

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!