I am experiencing some strange behaviour when pasting data from access into
excel.

Firstly all numeric values i paste will not sum so i have to convert them to
numbers with =Value() function.

Secondly if I try and select the pasted area and click on cell format it
wont load but if I select some cells which I didnt paste into I can load the
cell format dialog box.

This has only started happening recently and I can't figure for the life of
me what is happening. Can anyone help?

TIA