Excel is seeing them as text; it's very common. See "Data isn't
recognized..."
http://www.officearticles.com/excel/...soft_excel.htm

************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Rock" wrote in message
...
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