It still didn't work. I was able to change the numbers but the formulas
didn't work. I
also cannot add these numbers.
"Niek Otten" wrote:

Format an empty cell as General. Put the number 1 in it. EditCopy. Select your cells with the "numbers". EditPaste Special,
check Multiply.
Now the cells are real numbers. That is, if they don't contain spaces or other invisible characters.
Post back if they do; that can be remedied too.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rookie" wrote in message ...
| In reply to my own post, I have found that I can use the AVERAGE formula and
| IMSUB on a blank worksheet that I input the numbers manually. However, if I
| copy/paste data into a worksheet I can no longer use those functions.
| However, I can use ADD. I have checked the format of the cells and it
| doesn't seem to matter if I have them formated as "general" or "number."
| There's way too much data to input everything manually and that would defeat
| the purpose of having excel. Can anyone help me overcome this obstacle?
| Thanks.
|
| "Rookie" wrote:
|
| I have been trying to subtract 2 simple numbers. I can do it by entering the
| formula =123-111 but would to make a formula where I could use the cell as a
| reference (ie H2-H3)
|
| I have also been trying to find the average of 2 numbers. I use
| =AVERAGE(H2,H3)
| I get #DIV/0! I can't seem to get it to divide by 2.