=--LEFT(A1, LEN(A1)-5)


--

HTH

Bob

"kenppy" wrote in message
om...

This works but is still a string, how do I turn this to number?
thanks
says...
=LEFT(A1, LEN(A1)-5)

Will return your data as required as long as the text to be stripped is
constant