Cell Format

[arrowhead42]

I know this must be something very simple, such as the cell format or something, but I can't figure it out.
When I type in

=sum(b2:e2)

That's exactly what shows up. The formula doesn't calculate anything. I think the cell may be formatted to show everything as text, but if so, what format do I change it to, in order for it to calculate the values? Scientific? Currency? Time? I've tried them all, and nothing makes the formula work.

 

[jmthompson]

Or if you want to avoid VBA, enter a 1 into any cell, copy the 1, select your range of "numbers", paste special- multiply. Voila, your numbers are now numbers

 

[arrowhead42]

Awesome! Thank you so much!