2012 ACS 1-year estimates are now available

The "numbers stored as text" issue in Excel is easily fixed by typing 1 in a different cell (say J1). Copy J1, highlight the entire range with "numbers stored as text" and right click -> Paste Special -> Multiply. This coerces the text into numbers whereas Excel formatting often still leaves the original values stored in a non-number format.

The "numbers stored as text" issue in Excel is easily fixed by typing 1 in a different cell (say J1). Copy J1, highlight the entire range with "numbers stored as text" and right click -> Paste Special -> Multiply. This coerces the text into numbers whereas Excel formatting often still leaves the original values stored in a non-number format.