formatting in calc

edit

I did a spreadsheet and discovered the default cell format is text(crazy for a calc progam) Now I can't change the format except 1 cell at a time. I try by row or column and even though it shows changed to number it isn't. The numbers are still text and formulae will not read them. Frustrating. Any way to correct this issues???? Thanks