Claus Busch said:

Hi Emrys,

Am Wed, 23 Apr 2014 19:17:47 +0100 schrieb Emrys Davies:

real numbers are right in the cell. If the numbers are on the left side,

the numbers are text formatted. Therefore you see the green triangle.

Write a 1 in an empty cell, copy this cell, select your numbers and

choose paste special => Multiply.

Regards

Claus B.

Claus,

Sorry, but that did not work. I got to Paste Special and Paste as Unicode

Text was revealed. I clicked OK and a little suitcase parked itself in the

correctly placed '2' cell. As you will have gathered I am not much into

this so would you kindly talk me through it with a little more detail. = >

Multipy did not reveal itself. In short I have 4 columns of numbers namely

at columns B, D, AT and AS and all of them except one are on the left hand

side of the cell. The first two columns have numbers 21/12 or similar and

the last two columns comprise single or double digits. Thanks.