PTV Visum - Frequently Asked Questions (FAQs)

(#VIS17038)

When exporting or copying to Excel (by file or clipboard, of lists or matrices) number formats or number values are sometimes changed. Why?

This might be related to the setting for the decimal symbol as point or comma, which needs to be equal for both Visum and Excel:
- Excel can use the corresponding Windows setting: Control panel -> Regional and Language -> Format -> Additional settings/Customize -> 'Decimal symbol' and 'Digit grouping symbol'.
- Excel 2010 can override this option: Excel Options -> Advanced -> Use system separators -> 'Decimal separator' and 'Thousands separator'.

In Visum this is a program setting:
- Visum10/11/12: Extras -> Options -> Formats -> Decimal separator.
- Visum13/14: Edit -> User Preferences -> Formats -> Decimal separator.