How to remove trailing zeros after decimal from table exported from excel to Inventor Drawing?

How to remove trailing zeros after decimal from table exported from excel to Inventor Drawing?

sohaib.as01
Advocate Advocate
596 Views
2 Replies
Message 1 of 3

How to remove trailing zeros after decimal from table exported from excel to Inventor Drawing?

sohaib.as01
Advocate
Advocate

Hello Everyone.

I have some drawings made up which have tables that are linked directly to an excel spreadsheet. Now every numerical value is working fine except one, which is giving me a long trail of zeros after decimal. For example if the value in excel is coming out to be "58" then in the table of Inventor drawing, the value changes to "58.000000001". I have done everything in my knowledge to avoid that but nothing works. 

How can I avoid this issue, your help will be highly appreciated.

0 Likes
597 Views
2 Replies
Replies (2)
Message 2 of 3

johnsonshiue
Community Manager
Community Manager

Hi! Do you mind sharing an example that exhibits the behavior? I believe there are settings to change that. I would like to understand it better.

Many thanks!

 



Johnson Shiue (johnson.shiue@autodesk.com)
Software Test Engineer
0 Likes
Message 3 of 3

hosford
Collaborator
Collaborator

is the 58 a calculated Value?

Thaddeus Hosford
NUC9i9QNX i9-9980HK, Win 10 Pro 64
Nvidia GTX 1650
Inventor 2021