How to convert a Numbers spreadsheet from mm to inches

dorald wrote:

Ian,

one could enter a number in mm, hit ENTER and that entered number would convert into its imperial number. Does this make sense and is it even possible? Or would I need to use more “cells”? Maybe enter a mm value in one cell and have the formula for conversion in another cell?

You need more cells to contain the conversion formula(s) and display the result(s). The easiest way, so you don't have to worry about getting the conversion factors right, is to use the CONVERT function, something like this:

In this simple example, I entered this in B2, and filled (or copied) it down the column.

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

CONVERT can do lots of other conversions too. More here, with examples:

CONVERT - Apple Support

SG

Hi dorald,

I don't know about millimetres, but Numbers allows centimetres and inches.

Menu > Numbers > Settings > Rulers > Ruler Units

Regards,

Ian.

Edit: Or do you mean paper size? For example A4 versus US Letter.

More information may lead to a solution.

Ian.