Why are these numbers as text

  • Thread starter Thread starter Rock
  • Start date Start date
R

Rock

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.
 
Back
Top