You may have spaces included with the digits.

try doing a find replace and replace spaces with nothing.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"Cole" wrote:

Hi
I have downloaded data from the web and put it into excel. When I use cell
contents that appear to be numbers in my formula i get #value. The cell is
formatted as number. I have tried entering a 1 in a blank cell and
copypastespecialmultipy, but this does not work. If I edit the cell and
over type one of the digits (8 digit number) the formula works. How can I
fix this without having to edit each cell?
Thanks