Pivot table not seeing data as numeric, hence SUM does not work...why?

[mostlydice]

I have a created a pivot table to sum data on three columns. They are numeric , but the Pivot table will not see them as numbers, hence will not sum them.

The reason I know this is if I do COUNT, it will count the rows. if I do Count (Numbers Only), it will not count.

How do I get the Pivot table to see the data that IS numeric , as numeric.

[robleyd]

Just because they look like numbers does not mean they are stored as numbers. Press F8 or toggle View | Value Highlighting and look at the colour of the cell entries; text cells are formatted in black, formulae in green, and number cells in blue.

Look at Menu=> Data | Text to Columns for converting numbers formatted as text to numbers.