I think your second problem is the key:
....it won't let me change the format in other columns...
Both problems could be explained if you had
extra spaces, CHAR(0160) in your cells.
Find/Replace ALT+0160 in all cells.
Type the number from the keypad.