I would say the easiest way would be to use datatext to columns, then click
finish

--
Regards,

Peo Sjoblom



"Sune Fibaek" wrote in message
...
Hi,

Easiest way: enter a single 1 in any cell. Copy it (ctrl+c). Select the
range, you want converted. Select edit/paste special. Check values under
paste and multiply under operation. Click OK.

/Sune

"kevcar40" wrote:

Hi
i have a column of data in the form of a string
ie 123 i want to convert this to a number
the problem is that the sting has a space at the beginning
How do i remove the space and convert this string to a number

thanks
kevin