Excel not recognising data

Hello,

I have a bit of a problem with Excell/Access. I have and Access query which draws data which I then export to Excel. For some reason that is beyond me, When I try to Pivot the data in Excel, it just give me 0. Even when I try to sum the data without a pivot it gives me 0. Ive check the format of the fields in Access which are set to Number. Ive even tried changing the format in the Query to General Number, but nothing seems to work. Has anyone else had this problem?

Thanks

Odds are that excel is has the 'numbers' as text - try reformatting them as numbers in your sheet.

Ed

Thanks for the reply. Ive tried that. I even tried copying the data and pasting values to a new workbook and still the same problem... Sometimes I hate Excel.

have you checked by using ISNUMBER(cell_ref)

This will tell you if this is the problem

Ed

Maybe this will help
input "1" in an empty cell somewhere
Copy this cell
Choose the range with the numbers you are not sure are real numbers
right-click
Select Paste special
Select Multiply
OK

HTH

Ah ha! Seems that its not in number format... Which begs the question... how do I change the format? Ive tried Format - Number and that doesnt work.

thanks!

Originally Posted by LB79

Ah ha! Seems that its not in number format... Which begs the question... how do I change the format? Ive tried Format - Number and that doesnt work.

thanks!

Did you have a go at my suggestion?