Try using EditReplace

Select the range of cells that hold the numbers
Goto the menu EditReplace
Find what: enter a space by hitting the space bar
Replace with: nothing, leave this blank
Replace All

--
Biff
Microsoft Excel MVP


"Coley" wrote in message
...
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?