Jump to content
Martin Crawford

Worksheet Formatting

Recommended Posts

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

Share this post


Link to post

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.

Share this post


Link to post

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

 

Share this post


Link to post

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.

Share this post


Link to post

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

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...