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

[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!

 

[Domenic]

Hi,

Try,

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

Hope this helps!

 

[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

 

[Peo Sjoblom]

Try

=INT(A1/100)

--


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

Regards,

Peo Sjoblom

 

[ifew552]

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