User Profile
danielaanchico
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: The visualization of the numbers in excel is not "correct"
NikolinoDE Hello there! Thank you for your answer, I really appreciate it, but unfortunately it didn't work 😞 The advanced settings in my computer are already like you said. I changed the format of my cells and refreshed the pivot table, but the problem still the same there and in my cells of the column from the database:The visualization of the numbers in excel is not "correct"
Hello! I hope everyone is great. I'm here with the hope of solving my problem. I have to do an assignment for uni, and we have to work with a database from the DANE, a departmet of stadistics about my country, Colombia. Here is the link: https://microdatos.dane.gov.co/index.php/catalog/708/get-microdata We need to use the ones called "Hogares" and "Personas". The problem comes when I have to work with the colum "lp", or "ingtot", among others and do some PivotTable. As you can see in the image, the numbers are very long, but Excel is not making them "smaller". It's a big deal cause, when I'm doing the average, the numbers still like that, and it's not possible to do the correct analysis of people being poor or not. For example, someone that won 2.3 billion pesos, appear that is poor, because the number was less than the poverty line. This database is the same for every of my partners, but for them, the numbers are right, as you can see here: A comparison between my pivot table and the one of my partners: Although in the formula bar, the numbers appear complete, in the pivotTable, the numbers show like this, and it's in this form that I need them to be, so I can continue doing my job. I have already tried to change the system separators, but it hasn't work. And yes, I have tried to change the format of the cells many times too. If anyone could help, I would be really grateful
