I need to do calculations on a column of numbers I have imported(copy &
paste). The calculations do not work and I have discovered that the numbers
have a leading blank space. I have tried to format as number but does not
work. If I edit each cell and remove the leading blank space all is well.
This is too time consuming. How can I format or edit more effeciently?