I displayed Trades ($). Then I right-clicked the first column of Trade 1, then selected Export... Using this method, I exported the data to Excel, but when I attempted to change the number format of the Profit column via clicking the column heading, then right-clicking format cells, then clicking on number to change the color of the negative numbers, I get an error message on each cell which says "Number Stored as Text". I can click on "Convert to Number", but I would have to do this for every cell.
Is there any way to convert all the text within a column to numbers without having to do it for each cell?
Thanks-
Rick
Comment