Error saying number isformatted as text or preceded by an apostrophe

[sobrien1234]

I have downloaded data from the internet in column A and it all appears as numbers however when I write a formula on column B using those numbers it doesn't work.

I notice a ! in column be that says the number is formatted as text or preceded by an apostrophe.

How can I write a formula (say in column C) to get rid of any formatting/apostrophe issues? Assume A1 and the formula will be in C1

Thanks

 

[jtakw]

Hi,

Select Column A, Click on that ! symbol, scroll down, second option (I think), "Convert to Number"

 

[sobrien1234]

I need a formula in column C as I have to do this multiple times (100 times a day) - it would take too much time.

 

[jtakw]

It will take "too much time" to do a total of 3 ( Three ) clicks???

1 click to select entire column A
1 click on the !
1 click on "convert to numbers"

But if you want to do it the hard way:

In C1 copied down.

=A1+0