Worksheet Formatting

[Martin Crawford]

How can I convert a mm dim to feet and inches. I can do the math and get a decimal number, however I would like to display as 10' 5 3/16"

 

I see there is a FormatField option as a function, however I am unable to find any documentation on how it works.

 

Thanks

 

Martin

[Pat Stanford]

Have you tried formatting the cell as a Dimension?

 

Worksheet Menu:Format:Cells...:Number Pane.  Dimension.

 

The style of the dimensions will be set in the Document Preferences.

[Martin Crawford]

That would be wonderful, except the drawing is in mm, and I am trying to convert to Feet - Inches and Fractions that Construction crew uses.

 

Thanks

 

[Pat Stanford]

Would you be willing to have one column showing the mm value and another showing the feet-inches? If so, I think we can come up with a work around.

[Martin Crawford]

That could work.

 

Thanks

 

Martin

[Nashalyn]

When you scale this drawing set the value and aside the unit like:
actual distance: 36'30"
new distance: 80 m
 

[John Medland MAIBC]

Pat Sanford, did you ever figure out a work around for this? My windows are in imperial, but would like a metric conversion into mm on same work sheet as often getting windows quotes in metric.

[Pat Stanford]

Sorry for the delay. Crazy week.

 

Worksheet Function Documentation is available here:  https://developer.vectorworks.net/index.php?title=Worksheet_Functions#General_2

 

What the original poster was looking for (or kind of looking for) is a way to generate a display of Feet & Inches from a dimension in millimeters.  The worksheet TXT function will generate a string representation of a dimension conversion. It will be a string and not a number, so you can't use it in calculations.

 

In a document with Dimensions set to millimeters, and a dimension value stored in cell A3, this function will return a string showing the feet and inches value with fractional inches rounded to the nearest 1/16th of an inch.

 

=TXT(A3, 'FeetNInches', 'Frac', '1/16')

 

 

If you are in a country that used the comma as the decimal point in numbers you will need to use semicolons [;] to separate the function parameters instead of the commas I have shown.

 

HTH.  Ask if you need more help.

[Elite Exhibits]

@Martin Crawford Connect with @MullinRJ - I purchased a set of items that keep my Metric Metric and Inches inches in Worksheets - Works Great !  (Saves me every job...)

 

Peter