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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mis-performing MP4 files in Mac PPT 1
Word VBA - Delete text from bulleted paragraphs 1
VBA Export to PDF 0
Incone & Expenses Statement 0
type mismatch error in macro in excel 0
Page numbering with Merged Document and IF statements 1
How to save a PDF with header that extends to edge of page? 3
Using Drop Down list to an If Statement to another Drop Down list 3

Top