If the cell in Excel is set to a Number format such as Number with the number of Decimal places set, then it should be displayed as such in the Table in MicroStation. i.e. With number format set to 2 decimal places
Excel |
Current behavior |
Should be |
1.00 |
1 |
1.00 |
0.90 |
0.9 |
0.90 |
1.23 |
1.234 |
1.23 |
Hello David,
In Excel, I have 3 column of data formatted as number with different decimal places for each column. The column header matches the number of decimal places for each column.
In MicroStation 2025 (25.00.01.62) I placed the Table from Excel and the format is correct in all columns.
What version of MicroStation are you using?
Regards,
Tamicca Sellars
MicroStation Product Manager