How do I convert 300616a to show as a number 303616?

S

SusanK

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?
 
K

K.S.Warrier

Hi,
try :-if A1=300616a,then
B1=left(A1,6)=300616 (6 in the formula shows the first 6 in A1
Thank you,
K.S.warrier
 
K

Ken Wright

The downside to that is that the LEFT function returns a text string, hence
if you look at Frank's response you will see the double unary preceding his
use of the function, as this coerces the data back to numeric.

Regards
Ken...................
 
Top