Figures read as text and numbers in the same column

[Saturn]

I have a big worksheet with a columne with figures. Some of these figures are read as numbers, other are read as text.

The figures are not actually numbers but rather model-identificators so it is not a task to summarize them.
These 'model-id's have other data connected to them in the table so I have made a pivot-table
in order to sort data connected to the various model-id's.

The problem is that some of these model-IDs er read as numbers, others as text.
Because of this the pivot lists up a model-ID at two separate places in the pivot-table.

Looking at the table I am not capable to identify which are read as what. They have the same cell format etc.

I have tried to change the format in the column to Text and Numbers. It doesnt help.

Is there a smart method to 'clean up' the column in the source table in order to have the figures to be read in the same format ?

[Pete_UK]

If you want to turn them all to numbers, then a quick way is to highlight the column then click on Data | Text-to-columns then click Finish. Note that you will loose any leading zeros that you might have.

If you want to convert them all to text values, then you will need to use a new column, with this formula on row 2 (assuming you have headings in row 1):

=A2&""

which assumes the values are in column A. Copy this down, and then you can fix the values and copy/paste over the original values in column A.

Hope this helps,

Pete