Those numbers you have exported/imported could still be text -
changing the format (of the cell) will not change their value. A quick
way to change them is to highlight the numbers then click on Data |
Text-to-columns and then click Finish on the first panel.

Hope this helps.

Pete

On Sep 18, 11:46*pm, scott wrote:
This is a little strange. *I have exported data from one of our applications
into Excel. *I'm trying to total a range of numbers but it's just giving me
'0'.

I've formated the number cells to be 'numbers' and I've made sure the cell
i'm putting the 'SUM' formula in is formatted as 'general'. *but it's still
not working. *Anyone know what else I could try ? * There has to be something
simple I'm overlooking. *Thank in advance !