How can I fix wrong decimal values in Excel-Export?
SiDiary accepts both the comma and either the dot as a decimal char and doesn't matter, what is configured in your language settings. This is possible because SiDiary does not have to calculate with values in a range above from a thousand, and it interprets both characters as decimal characters. Unfortunately, Excel does not.
If you have problems that SiDiary is showing a decimal value like 5.1, but Excel displays wrong value 51, you can set up a fixed decimal character for the export functionality of SiDiary. Just add the following key to your SiDiary.ini file:
[Einstellungen]
:
:
DecimalChar=
Valid characters are comma and dots. SiDiary will now convert (after a restart) each decimal value before it is sent to Excel. You have to try out (it's dependant to your country), if the comma or the dot will help you - but one of them should make Excel display the correct values.
