Why are these numbers as text

Hi,

I have just exported some data in a table from an sql file to Excel and
have noticed that some of the figures in the column have a small green
triangle next to it with the message, 'it is formatted as text or has an
apostrophe in front of it'.

What does this mean?

I am trying to change a column of 0's to 1's then import it back into
sql, but after replacing the 0's with 1's, find that some have this
triangle.

I have searched the help files but can't find anything to help me.

Thanks

Rock

To convert "text" numbers to real numbers, put 1 in an un-used cell. Copy
this cell and paste/special with multiply checked onto the cells you want to
convert.
--
Gary's Student


"Rock" wrote:

> Hi,
>
> I have just exported some data in a table from an sql file to Excel and
> have noticed that some of the figures in the column have a small green
> triangle next to it with the message, 'it is formatted as text or has an
> apostrophe in front of it'.
>
> What does this mean?
>
> I am trying to change a column of 0's to 1's then import it back into
> sql, but after replacing the 0's with 1's, find that some have this
> triangle.
>
> I have searched the help files but can't find anything to help me.
>
> Thanks
>
> Rock
>