Right click change formatting?

You don't have to do this individually, you can select a whole column by clicking the column header like the A,B,C etc. Click on this column header, it should be highlighted and then do the formatting.

Be careful with changing formatting as sometimes cells contain a space or other strange characters that won't allow the change to number format.