Mine is an earlier version of Excel and doesn't have an option called application preferences. the strange thing is it used to work well for the fairly simple stuff I do on it.
I just opened an old spreadsheet and it works fine, it's just anything new I do
Update: even on the old, OK, Spreadsheet if I enter a new number if does the 45 to 0.45 thing but the previously entered data displays OK.