TTC will *only* correct numbers designated as 'text' by the use of a
prefixed apostrophe.
If cells were formatted as 'text' prior to the entry of the numbers, TTC
won't work on those cells.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ron Coderre" wrote in message
...
It sounds like the "numbers" are really numeric text.

Try this:
Select the range to be summed
<data<text-to-columns....Click the [Finish] button

That should convert any numeric text to actual numbers. Does the summary
cell show a non-zero total now?
***********
Regards,
Ron

XL2002, WinXP


"Stephen Connell" wrote:

I have a spreadsheet in which the sum function returns a zero value from
a
range with positive numbers. The sum formula is correctly entered. Any
ideas?

Thanks