close
 
Service - FAQ

Excel gives me incorrect decimal values for exported data. How can I get this fixed?

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 has to calculate with values in a range above from thousand and it is interpreting 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 setup 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 dot. 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.

Our awards

RATED WITH 5 STARS!

SiDiary received several top ratings »»»
iPhone Diabetes App Android Diabetes App Windows Phone Diabetes App Diabetes logbook on the PC

SELECT YOUR PLATFORM!

SiDiary mobile and at home »»»
List of our supported meters and pumps

ONE FITS ALL!

SiDiary reads more than 300 devices »»»
SINOVO on Facebook