add a digit

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

I have 800 three digit figuers ie 457,427 522.

I need to put another digit (7) at the begining so it will
be 7457, 7427, 7522 and so on please help me on this.

TIA
 
put 7000 in an empty cell.
copy it
Select your range to get adjusted
Edit|Paste special|check the Add operation button

clear that cell with the 7000 in it.
 

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

I need to add spaces to the beginning of my texts which are numbers 1
Adding a zero to the front of numbers 5
Need to extract specific data from a text column 2
Reconize the first digit only 1
if statement for number of digits 5
using the =page! feature to transpose a row to column 0
change first 2 digit ignore the other 2. 6
Calculating a Check Digit Routine 4

Back
Top