I there a way to set formatting in custom properties

Prachi

I'm looking for a way to set formatting in a custom property.
Property is 'double' and I would like to fix number of decimal places.
Currently all I see is the last whole significant digit in BOM. 
  ie. 1.00 entered shows as 1  -  .50 shows as .5  - 10.00 as 10
Since there is an implied tolerance with 2 decimals and for clarity of reading I'd like to see the whole number to 2 decimals.
This transfers out to CVS file as well and needs correcting in spread sheet.

john_mcclary

I usually set all properties as text, there is no math you can do on them, so no real reason I have ever need them to be actual numbers.

On export, you may find some programs like excel will still truncate the trailing zeros by default, even if you have it set correct in Onshape, or SW etc.
also some numbers may appear as dates in excel, like 3/8-16 for a bolt likes to come in as 3/08/16. Adding an inch(") symbol or some non numerical character can force excel to import that cell as plain text. Which can help you keep your trailing zeros as well. 

Otherwise, I do not think there is any way to set leading/trailing zeros in custom properties. You may need to create an Improvement Request

Prachi

Thanks John
That's the experience I've had. Excel is rounding as though it's numbers and truncating both leading and trailing zeros even if it's text.
Tried adding a dash in front but stull gets truncated.

owen_sparks

Still easier to source than "31-Feb's"

john_mcclary

I usually set all properties as text, there is no math you can do on them, so no real reason I have ever need them to be actual numbers.

On export, you may find some programs like excel will still truncate the trailing zeros by default, even if you have it set correct in Onshape, or SW etc.
also some numbers may appear as dates in excel, like 3/8-16 for a bolt likes to come in as 3/08/16. Adding an inch(") symbol or some non numerical character can force excel to import that cell as plain text. Which can help you keep your trailing zeros as well. 

Otherwise, I do not think there is any way to set leading/trailing zeros in custom properties. You may need to create an Improvement Request

Prachi

Thanks John
That's the experience I've had. Excel is rounding as though it's numbers and truncating both leading and trailing zeros even if it's text.
Tried adding a dash in front but stull gets truncated.

john_mcclary

Speaking of which, looks like I still have a couple of fasteners I still need to add text to in my library

I wonder how long it would take to get some 8-Jan hex nuts...

PeteYodis

Oh yes, "8-Jan's".  We'll get right on them... 

owen_sparks

Still easier to source than "31-Feb's"