| Technote # |
Title |
| 42 | When I import data into Excel, the format is incorrect. |
| Date Updated | Category |
| 21-08-07 | Excel Add-In |
| Products | |
| [STarStation 2.0][STarStataion 2.3] | |
An example of incorrectly formatted data is presented in the figure below
If STarStation is used on a computer that has the windows regional options set for any region other than English, data exported from STarSTation may be exported as text rather than as numeric values. The data set will therefore not be recognised by Excel as containing valid numbers. To correct this you will need to modify the language settings on your PC. 1) From the start button select Settings -> Control Panel. 2) Select the Regional and Language Options from the Control Panel.
3) Select the Customize button from the regional options tab.
4) On the Numbers Tab: a) ensure that the Decimal Symbol is set to the period or full stop symbol ("."). b) Ensure that the digit grouping symbol is set to comma "," c) Ensure that the List separator symbol is set to comma ","
5) STarStation and Excel must both be closed at the time the regional setting modifications are made, in order for new settings to take effect. 6) Click Apply to change the settings. 7) You should now be open STarStation resave the worklist in the Reports tab and repeat the import of the data into Excel. |
|
< |
|
| [ Close Window ] | |