First basic question:

If you enter a formula and it appears in both the formula bar and the cell,
odds are Excel thinks the material is just a text string Take a typical
problem cell:

1. clear the cell
2. format the cell as general
3. re-type (NOT PASTE) the equation
--
Gary's Student


"cjtj4700" wrote:

I am a very new user of Excel so bear with my "green-ness";

1) I have been creating links throughout my 13 sheet workbook, now when I
attempt to finish making these links today, the actual formula (=SUM(A36)) is
populating into the cell and not my data????

2) I have a section that I want users to be able to only select 1, like
"choose only 1" in a survey. When you select 1 cell, your previous selection
moves, etc.

Thanks in advance for the help~