Add zero to existing numbers

[Steelband]

Cell C146 formatted general contains numbers 81621 and continues to cell c500. Need to add number 0 for cell to read 081621
(Cell C147 reads 81721 and needs to read 081821)

 

[bartmaster]

Cell C146 = 81621
If you need to have 081621 in Cell D146 insert the following formula:

=TEXT(C146,"000000")

 

[Phuoc]

You can select the range C146:C500 and Format Cells as: 000000

 

[Peter_SSs]

Welcome to the MrExcel board!

Yet another possible interpretation of what you might want is this.
Test with a copy of your workbook.

Sub AddZero()
  With Range("C146:C500")
    .NumberFormat = "@"
    .Value = Evaluate(Replace("if(#="""","""",0&#)", "#", .Address))
  End With
End Sub

 

[Rick Rothstein]

If you only want the cell to display a single zero in front of the number (the value in the cell does not physically change, only its appearance), then you can use this Custom Format to do it...

\0#

Peter has given you a macro to use if this is not what you wanted.

 

[Steelband]

If you only want the cell to display a single zero in front of the number (the value in the cell does not physically change, only its appearance), then you can use this Custom Format to do it...

\0#

Peter has given you a macro to use if this is not what you wanted.

Thank you Rick. Reason I don't add the zero's is that there are more than 100 lines involved. I went to concatenate instead. Thanks to Peter, Phuoc and Barmaster for the input.