Hi,

1. To verify what is going on select on of the cells and then click the
Formula Bar - are there spaces before or after the number on the formula bar?
Most likely yes.

2. These may or may not be "spacebar spaces". Here is what I usually do,
highlight the entire range of numbers and press Ctrl+H. In the Find what box
type a single space, leave the Replace with box empty. Press Replace All.
This will get all the regular spaces, but others may remain. You can repeat
step 1 to verify if there are other types of spaces.

3. If there still are some spaces, select one of cells and click on the
Formula Bar, highlight a single space on the Formula Bar and copy it. Press
Esc once. Press Ctrl+H, select the contents of the Find what box and choose
paste. This will replace the regular space with the character you copied
from the cell. Click Replace All.

4. Hopefully this will clear up the problem. If not you need to post a
sample of the data. So we can see what you really have.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"sorrywm" wrote:

I copied some data into an Excel (2004) spreadsheet from the web, and now I
can't operate on the cells, despite the fact that their format is 'Number.'
I've tried re-copying the cells and paste-special-ing 'Value,' but to no
avail. Does anyone know how to make Excel recognize these perfectly good
numbers?