Unwanted Formula Display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Excel XP, preparing cost estimates.

In my summary page, cell references display the name and total of each
category, from the associated category page in the document.

When I insert a new line for a new category, and "point and shoot" to assign
the formula, e.g., ="A425", it displays the formula rather than the cell
reference value, e.g., "Carpentry". I've tried formatting the cell as Text
and General, copying another cell reference that is displaying correctly, and
then editing the formula, and painting the new cell from one that is
working--none work.

Can anyone tell me what's going on?

Thanks.

Sprinks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filling Formulas 2
VLookup 6
Formula Audit mode active in one column only; cannot kill. 2
Ref Formula 4
Formula is changing to text when I hit enter 6
Simple Formula displays "0" 1
Formula shows in cell instead of results (text reference) 4
Formula Result = Volatile ?? 3

Back
Top