Excel Format Issues

I was wondering if anybody in this forum could help me with this problem.

Here is my post on this on Codeguru
CodeGuru Posts

Anybody have any better ideas???

You have probably got the cells formatted as text.

What do I need to format them as???

I'll try to set the cells up as General - (though in the code I never change the cell format) as see if that does anything for me.

thank you