Is there a way to prevent this? On my computer at work, whenever Excel thinks that your data should be Text, it adds an apostrophe to the beginning of the cell, causing it to be seen as text no matter what type of formatting you actually select for it. So, if I need a column to be numbers, I basically have to insert a new cell, use the VALUE function and copy paste values.
I need to know if there is something I can do to prevent Excel from trying to guess what data type I want and stop putting the apostrophe at the beginning of the line?
I need to know if there is something I can do to prevent Excel from trying to guess what data type I want and stop putting the apostrophe at the beginning of the line?