2012 ACS 1-year estimates are now available

The 2012 American Community Survey 1-year estimates are now available at http://factfinder2.cesus.gov.
Parents
  • 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.
Reply
  • 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.
Children
No Data