Hello everyone,
I have a problem reading the units used in Solidworks Simulation.
In particular, the unit in the resulting displacement (URES). Here are my results, which I would like to have in mm!
URES (mm):
7.810E-002
1,000E-030
4.556E-002
My goal would be to create an XLS file that converted to "normal" mm....
Thank you!
These are values in mm
7.810E-002 corresponds to 0.0781mm
1.000E-30 corresponds to 0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
4.556E-002 Crooespond at 0.04556mm
The "e-xxx" is also written x10 to the power of xxx
The answer you have is 7.81 x 10^-002 or 0.0781
you write in your cell =7.81*10^-2
Hello
If the text as you pasted it here is in cell A2 in Excel for example, just put this formula on the same line:
=SUBSTITUTE(LEFT(A2; 4); "."; ",")*POWER(10; RIGHT(A2; 4))
See the result on the attached image.
In Excel, for values with low powers (such as -002s), you can directly copy the value into a cell and replace the period of the value with a comma. Excel recognizes the wording and gives you its value when written. (see image)
I think this one will be better if the data is in A2
=POWER(A2; 1)
Sorry @frédéric HUMBERT, if there is "7.810e-002" in A2, your formula doesn't work!
In my example I automatically replace the period with a comma and I separate the data into 2: a part for the decimal, a part for the exponent of 10.
Hello
Just edit by double-clicking on the graph of the Simulation results and switch to normal rather than scientific visualization, at which point instead of having 7.810e-002 you will have 0.0781
@+
EDIT: this can be hard-fixed in the simulation options
Copy your results to excel file, then pass decimal number format and possibly increase the number of digits after the decimal point.
7.810E-002 becomes .078100 etc.
But the easiest way is to change the format of the results directly in the app