Losing Formatting

Losing Formatting

Hi - I've recently been losing my Sheet formatting and even when I try to change things back it doesn't always work. This is affecting the formatting of dates, currencies and decimal places. Text formatting seems unaffected. The sheet in question is set up to display dates as 17-Aug-10 but when I load a saved sheet it seems to be in U.S. Date/Time format. Currency pages have either lost the pound sign £ or it changes to $ and numerical data that was set for 2 decimal places won't display trailing zeroes i.e. 210.10 displays as 210.1. This latter point is a particular nuisance as there doesn't seem to be a way of setting decimal places by column and altering it cell by cell is not quick. Hope you can help.