Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel
I have a range of values. A1 - C1
For example A1 = John, B1 = Q., C1 = Customer In cell D1 I enter =+A1 and get the value "John". However, the next time I do this I get the result +A1. The results in D1 have change from the value in A1 to the simple text entered in D1. Since A1 - C1 is a range I used in another sheet, I was wondering if I accidentaly changed something that causes cell reference to be swithed to constants. Thanks -- LongBow |