Hi
try
=--LEFT(A1,LEN(A1)-1)

--
Regards
Frank Kabel
Frankfurt, Germany

"SusanK" schrieb im Newsbeitrag
...
I am trying to convert a number ending with a letter to just the
number. In
there a function in excel that can perform this task?