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

--
Best Regards,

Luke M
"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