If the cells are formatted as currency then you need to go into Control Panel, Regional and Language Options (in Windows XP) and check that the £ is selected as the currency and United Kingdom is set as location.
This thread is now locked and can not be replied to.
How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…
1995-2015: How technology has changed the world in 20 years
Alex Chinneck’s giant ice cube Christmas tree at Kings Cross