I have this excel with the following data in column A

'1234567891234545
236556545454554554
'45454545455458475258
4845487845155484844
4848745125154545454

I want to do the following:

1) remove the extra space dat comes in the front of a few numbers.
I've tried trim - it dint work.
I've tried substitute - it dint work.
I've tried text to column - dint work either.
I've tried find and replace - it still dint work.

Ok wat worked is this - I copied the space from the function bar, and then i
did a find and replace of the copied space - it worked!
However, the number got converted into its exponential form.... smthg like
236556545E0...
I want to remove the space and keep the number as is. Please help!

2) i want to remove the single quotes before the number.
I did a find and replace.... the excel did not find any quotes.
I tried text to column and converted it to general. This removed the quotes.
but once again, changed the number to the exponential form.... or sometimes,
just rounds off the last digit to 0...

i want to remove the quotes without it changing the numbers.