Pivot Table in Excel only counts the rows

[ajt8888]

I have a weird workbook which is published nationally but will only count the number of rows or alternatively return zero values even though the Total column is formatted as numbers. Its driving me mad. The Pivot is on the Data Sheet

File

 

[etaf]

it thinks its text, I notice the numbers are left justified
I copied the numbers into a different cell , and added 1 and they seem ok
but when i copied and paste back - then it works

So i think something is off with the formatting

 

[ajt8888]

I have a weird workbook which is published nationally but will only count the number of rows or alternatively return zero values even though the Total column is formatted as numbers. Its driving me mad. The Pivot is on the Data Sheet

File

Ok I have fixed it the column of numbers was formatted as numbers but was actually text, I found this article Fix text-formatted numbers by applying a number format and ran "Text to Columns"

 

[ajt8888]

it thinks its text, I notice the numbers are left justified
I copied the numbers into a different cell , and added 1 and they seem ok
but when i copied and paste back - then it works

So i think something is off with the formatting

Thanks for your help

 

[etaf]

you are welcome
glad text to columns fixed it, I tried that first and did not work for some reason
anyway - all sorted now