Convert mm to fractional inches

Hi,

I have a column with measurements in millimeters and I want to convert them to proper fractional inches.

i.e. 29mm in one cell needs to be converts to 1 1/4.

As well as the above, I the fraction should be no smaller that 1/8. In other words I don't want 16ths or 32ths. Just 8ths, Quarters & halves. It should round to the nearest fraction.

I did look at some other posts but couldn't find the right solution.

Thanks

in = mm/25.4

Format as a fraction or however you wish.

Originally Posted by shg

in = mm/25.4

Format as a fraction or however you wish.

Thanks for you quick answer.

However, that's what I already do though. Sorry I didn't mention before. I don't want to have to mess around deciding which is the appropriate fraction to format to as there are well over 400 measurements that need converting.

e.g. say the measurement was 19.05 then the proper fraction is 3/4. You wouldn't normally write this as 6/8. I want excel to format this correctly.

If you load the Analysis Toolpak add-in,

=MROUND(mm/25.4, 1/8)

... and format as # ?/?

Hi

Or

=CONVERT(mm,"mm","in")

and format as per shg.

Richard

Originally Posted by shg

If you load the Analysis Toolpak add-in,

=MROUND(mm/25.4, 1/8)

... and format as # ?/?

This works exactly as I wanted.

Thanks all for the other suggestions, I did try them but found this was the best solution.

Thanks for the help