Excel gives me incorrect decimal values for exported data. How can I get this fixed? (V5)
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 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 commas 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 on your country), if the comma or the dot will help you - but one of them should make Excel display the correct values.