Trying to pull a 0 using LEFT fuction

jjst34 · Nov 16th 2004

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!

**Andy Pope** · Nov 16th 2004

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?

jjst34 · Nov 16th 2004

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"

**Andy Pope** · Nov 16th 2004

Re: Trying to pull a 0 using LEFT fuction

In that case you will need to format the contents of D2 before trying to extract the first 2 characters.

Code

=+LEFT(TEXT(D2,"0000"),2)

jjst34 · Nov 17th 2004

Re: Trying to pull a 0 using LEFT fuction

ok, sweet.. thanks that works great. Thank you!

Trying to pull a 0 using LEFT fuction

Participate now!

Share