On 3 Jul, 16:36, Sune Fibaek
wrote:
Yes, one might argue that :)

(Okay, you'r right. But the other method isn't all that difficult either.)

/Sune



"Peo Sjoblom" wrote:
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- Hide quoted text -

- Show quoted text -

THanks both
this does not remove the leading blank space