USING TRIM STATEMENT

B

Barbara K

Number = 00557081002000 - Would like to see 557081 - Using =TRIM (B2*1) -
shows 557081002000. How do you crop 002000?
 
I

IC

It looks like your original number was stored as text otherwise the
preceding zeros wouldn't be there. Multiplying by 1 gives the result as a
number. TRIM does nothing as it only removes leading and trialing spaces.

Try =INT(B2/1000000)

Ian
 
J

JE McGimpsey

If your numbers are actually text, use

=MID(A1,3,6)


If they're actually numbers, but with leading 0's formatted, one way:

=INT(A1/1000000)
 
Top