Formatting Data

These pages will deal with problems in preparing data from downloads that is not in a suitable format for using with spreadsheets or database problems.

Numerical data downloaded as text: Data downloaded from websites as spreadsheets occasionally contains numerical data that is formatted as text (A problem with UNAIDS data among others). When there are no text characters in the data the data can usually be converted simply by selecting the problem cells, right clicking and then using the format option in the drop down menu to reformat the cells.  The situation is more difficult when the cells contain text characters which must be removed, or even two or three data elements separated by text character. For a brief description of how to deal with this problem in a spreadsheet click here.

Copyright 1998/2015 GRI    Updated 5 May 2015