#VALUE!

R

Rock

Hi All,

I copied a spreadsheet from a website into excel. I wanted
to used the numbers in the spreadsheet to create my own
formulas. When I created the formulas and tried to
calculate them, I received the #VALUE! error. I then typed
over a couple of the numbers in the different cells that
were in the formula and then excel made the calculation.

Does anyone know how I may be able to fix this problem
without having to retype every number in the spreadsheet?

Thanks!
 
R

Ragdyer

Try this:

Select an "new", empty cell, right click and choose "Copy".
Then, select the cells with the "bad" numbers,
Right click in the selection, and choose "PasteSpecial".
Click on "Add", then <OK>.
 
G

Gord Dibben

Rock

Try copying an empty cell then selecting your range of "numbers" which are
likely text.

Paste Special(in place)>Add>OK>Esc

If that doesn't work, you may have non-breaking space characters in the cells.

See David McRitchie's site for info and TRIMALL macro to remove these.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Gord Dibben Excel MVP
 
Top