ok. I have this formula in cell E2:
=+LEFT(D2,2)
D2 says 0100 and I want E2 to return 01, but it keeps ignoring the first 0 and returning 10. Any help is appreciated. Thanks!
ok. I have this formula in cell E2:
=+LEFT(D2,2)
D2 says 0100 and I want E2 to return 01, but it keeps ignoring the first 0 and returning 10. Any help is appreciated. Thanks!
Re: Trying to pull a 0 using LEFT fuction
Hi jjst34,
Does D2 actual contain 0100 or is that how it appears because of some formatting?
Re: Trying to pull a 0 using LEFT fuction
well D2 is extracted from a text file which actually says 0100, but when it comes over to D2 it comes over as 100, so i have the whole row formated as a custom "0000"
Re: Trying to pull a 0 using LEFT fuction
ok, sweet.. thanks that works great. Thank you!
Don’t have an account yet? Register yourself now and be a part of our community!