Slight adjustment there,

=LEFT(A1;LENGTH(A1)-1)*1
Should be
=LEFT(A1;LEN(A1)-1)*1

And just to expand a little
=LEFT(A1;LEN(A1)-1)
will return the number as text.

HTH
Martin



"Hansueli" wrote in message
...

=LEFT(A1;LENGTH(A1)-1)*1

Rgds. Hansueli