Text Error Message

G

Guest

I typed some verbage into a cell that was to be a column heading. At the
same time, I also typed verbage into several other cells that were to be
column headings as well.

When I went to run a pivot table I got an error message that said I needed
columns with labels. I selected the row in which I had typed my information
and tried to format these cells as text.

The contents of two of the cells were changed to ###########.

I have not seen this before. What is happening? I need these ceels to be
text in order to run a pivot table.
 
D

Dave Peterson

Change the format of that ##### cell back to General.

Then look for other fields that are missing labels (probably empty cells in the
header row???).
 

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

Top