Hi Emrys,

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

I have a spread sheet set up in Excel 2007 and in column AT I have a list of
numbers. All are lined up nicely on the extreme left of the column except
one, the number 2, which sits in line with the others until I leave the box
and it then jumps to the extreme right of the column. All but this one has
a little green triangle in the top left hand corner of its box. Can you
remedy this? I should add that I have made the default setting for
text/numbers.

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional