Gord: Yes I have Automatic turned on in Tools-Options-Calculation.
Yes I think I am entering 1.10 in what I hope and think is an unused cell.
It is a blank cell on the same sheet. Is there another way I can try it to
make sure I am using a blank-empty cell?
I will play with it a little more to see.
Also reference old version (2000) I think one of the other girls has Office
2003 on her computer so I will make a copy of this and take it over there to
see if I have any luck.
--
ShirleyF


"Gord Dibben" wrote:

Shirley.

Are you entering the 1.10 in an unused cell in the same worksheet as your range
of data to convert?

From your description it sounds like you have two insatnces of Excel open and
you are copying from one to the other.

For the second problem with the formulas, do you have ToolsOptionsCalculation
set to "Automatic"?


Gord Dibben MS Excel MVP

On Thu, 27 Dec 2007 04:18:01 -0800, Shirley
wrote:

For Bill andSuleman:
Appreciate both your responses and tried both suggestions.
Reference Bill suggestion - when I get to the point of Edit-Paste Special I
do not get the window with all the Operations on it. Instead under Paste
Special I just get two options to paste as Unicode Text or Text. Dont know
what the problem is.

Reference Suleman suggestion - when I use the formula it correctly gave me
the result in one cell only (the first cell). When I used the formula in a
range of cells it gave me the same result in all cells which of course is
incorrect.

Any addtional suggestions would be most appreciated.
If it is any help the cells I am trying to add 10% to each one a
C5 thru C200
D5 thru D200
E5 thru E200