HELP!! need to get rid of last 2 #'s

I

ifew552

Please help. I just need to get rid of lat 2#'s of value.

EX. On colum L cell #3 I have 12345678912. I need to drop last 2 #'s
(to make it 123456789 on colum M). thanks for your help!
 
A

AlfD

Hi!


Put in M3 =LEFT(L3, LEN(L3)-2) (result is text)
or
=1*LEFT(L3, LEN(L3)-2) (result is number)
or
=INT(L3/100) (result is number)

Al
 
P

Peo Sjoblom

Try

=INT(A1/100)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
I

ifew552

thanks for yall's help!!!!! I'll try all of them to see if works. no
I can get back to work!! thanks!
 
Top