How to automatically add 000 at the back of my numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
If they are NUMBERS (not TEXT) multiply them by 1000. If they are TEXT
concatenate the cells with "000" i.e. =A1 & "000" OR =VALUE(A1)*1000; the
latter will convert the text to number format.

HTH
 
You must log in or register to reply here.

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

how to extract 20 000 lines out of 200 000 lines automatically? 4
how do i make #'s auto and 000 behind large numbers 4
filtering for numbers ending in 000 3
Excel Sequential Numbering System 0
Access Making a memo in Access 0
Phone number format from 000.000.0000 to (000)000-0000 4
Number Format 2
order of magnitude constants 3

Back
Top