Here is a newbie question.
I am using Excel 2007.
I had been using a Excel 2007 for a year now and I have to make changes to
it now.
About 6 categories that I have to keep up with have been dropped from a
report that I use.
When I deleted those categories from the spreadsheet, I get a invalid
reference on the sheet.
In cell A24, I am trying to reference the contents in cell A58.
I type in cell A24, =A58, and what I get is an equal sign with a blue 58 to
the right of the = sign.

Bottom 3 Categories





Product

Group
This Year
Last Year
Net




Sales ($)
Sales ($)
Sales ($)

=a58

180171
0
0
0

=a9

170117
125
235
-110

=a41

60400
5302
4746
556

Total :




446

Top 3 + Bottom 3 =



576



The contents in A58 is something like "bathroom".
I would like cell A24 to be filled in with the word "bathroom".
A58 is marked as "text".
What am I doing wrong?
Thanks