Consolidate Not Working

Hello,

the numbers in column B are text, not real numbers. Therefore, there is no numeric data to consolidate.

Convert the text into numbers this way: Select B4 to B122, click Data > Text To Columns > Next > Next > Finish.

Now the data is numeric and you can consolidate it.

For future reference, there are 2 clues in your data that indicate it is not text...
1. text is generally left-aligned, while numbers are generally right-aligned
2. if you look at the cells B4, for instance), you will notice a small green triangle in the top left of the cell. If you click on the cell, a yellow diamond will appear - click on that and a window will pop up telling you that the cell contains numbers stored as text.

If you see that, all you need to do is highlight the entire range, scroll back to the top, click the yellow diamond and click "convert to number"

Also, formatting is purely cosmetic, it does not change the underlying data, only the way it appears. If it was a text number before formatting, it is still a text number after formatting

The green triangle Error checks are an application level setting and not stored with the file. The OP may not have that error checking turned on. Many people don't.

Originally Posted by teylyn

The green triangle Error checks are an application level setting and not stored with the file. The OP may not have that error checking turned on. Many people don't.

Good point, thanks