Actually, those characters should match whatever the user has as a list
separator.

In the USA, most(?) people use a comma. In Europe, most(?) use a semicolon
(;)--not a colon.

I don't think many people use colons for this list separator.

MartinW wrote:

And another adjustment.

Those semi colons ;
Should be colons :

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



--

Dave Peterson