Dear Colleagues,
I am having issue when downloading data in excel from pivot table. I am getting number with an additional .0 and the downloaded numbers are in text format. I am using DHIS2 2.36.11
Can someone help me with the fix
1 Like
In Excel, you can change the number of decimals by selecting the column and then from the Home tab, click Decrease Decimal icon will look like this: 
@Thanks AL_GAssim for your answer. I am using the method you describe since 2 weeks now but I would like to have a ready to use excel file as it use to be on previous release version
warm regards
Amza
May I ask what metadata does the number 0 in the picture you posted represent? Data element, indicator…etc? If Data element then what type? (:
@AL Gassim, the value are of type Number. They are data elements.
warm regards,
Amza
Hello everyone,
When we download the data in Excel (xls) it looks like this with a dot at the end of the numbers.
How do we deal with this? We are on version 2.39.1.1
This is the formatting options for the numbers which is why even when you try to edit the cell, it’s not there; however, if you want to remove these dots you can select all the fields and format the cells by changing the formatting to Number and removing the decimal points at the end.
If you don’t need the formating you can export as CSV from the app and then import them to your spreadsheet software. I used Google Sheets:
Thanks!
Thank you @Gassim. However, this did not always happen like this. What changed? Can it be changed back so that folks do not have to do these extra manipulations?
Hi all,
I am following this thread to understand if there’s a better way to deal with downloading data from the data visualizer to ensure the data are stored as a number - particularly when some users have a french version of excel. For all of the program indicators where we didn’t specify that there should be 0 decimal places, by default, it downloads with 1 decimal place (.0). But they are stored as text for users in francophone countries unless they manually change to ,0 - which is tedious. And for me, sometimes I can easily change to number and sometimes I have to click into each cell to change. CSV works better to download as numbers, but replaces the indicator names containing french characters with nonsense (see attached for “dépistés”). Wondering if anyone found a solution for specifying that you want pivot table data stored as a number when you download. Thanks!
No solution yet that I know of for this. We are still seeing the decimal after the number and not sure why.