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.
 
Back
Top