So what type of spreadsheet are you using ANnuvver? Also what data source?
I've been using a google finance spreadsheet, however it's far from perfect. Especially when they start doing irrational things at random (for example, changing the units for sterling 52 week lows from pence to pounds, whilst retaining pence as the units for the share price and 52 week highs).
Google also only seem to have live data for USA and London, so I had to use Yahoo as a source for other markets.