Data display issue in Pivot Table

Hello,

I will rephrase to be clearer and without exclamation marks :)

1- I created a pivot table with a source file that includes:
Project name, start date, end date, project duration, days completed

2- In the pivot table, some data does not update in the days completed field. It appears in text format (seems to be left-aligned).

The solutions tested:

- Change the cell format to number format in both the source file and the pivot table (it doesn't work)
- In the pivot table options, I went to change retain data and set it to none
- Clear the cache of the pivot table

To date, nothing has worked; the pivot table does not take the data from the source file.

Indeed, Sabounette, you have the source file and you know how it is designed and organized; we have nothing at all! And we're not clairvoyants!!
If you don't know how to use cjoint.com, here’s a tutorial:

 1) Go to https://www.cjoint.com/ 
 2) Click on [Browse] to select your file (max 15 MB)
 3) Scroll down to click on the blue button [Create Cjoint link] 
 4) After a few seconds, the second page will appear, with the link in bold; right-click on it and choose "Copy link"
 5) Go back to your discussion on CCM, and in your message, paste it.
=>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers 
There are also: 
 1) https://mon-partage.fr/ 
 2) https://www.transfernow.net/ 

Best wishes to ALS35.

--
Retirement is nice! Especially in the Antilles...
Raymond (INSA, AFPA)

Well, ALS35...

Well Sabounette, the (too?) frequent use I make of the exclamation point is due to my lazy nature:
When I have both hands above the keyboard (with the numeric keypad), the key that is right at my right index finger is precisely

! §

-> I just have to drop my finger vertically...
Moreover, when reading aloud, this punctuation mark translates into a particular intonation that adds a precise meaning to the preceding sentence.

@ There, you see, I'm a bit embarrassed because I've forced myself not to use it in this message, even though I had the opportunity to do so several times ¤¤¤
:-)>
Best regards.

--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)