#VALUE!

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!

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rock" wrote in message
...
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!

Rock

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

Paste Special(in place)AddOKEsc

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

On Sat, 12 Jun 2004 11:56:13 -0700, "Rock"
wrote:

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!