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