Select your range, go to Data Text to Columns Next Next Finish


"Scott" wrote:

Hello,

I have a SUM( ) formula that is not working. The number format is "General
(not text)." I have also manually recalculated but I'm still getting a zero
for the total. Any ideas?

Thanks,
Scott