ExcelBanter - How do I create a macro to add a zero to end of a cell? or cel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How do I create a macro to add a zero to end of a cell? or cel (https://www.excelbanter.com/excel-programming/395678-re-how-do-i-create-macro-add-zero-end-cell-cel.html)

Monica

How do I create a macro to add a zero to end of a cell? or cel

Thanks Mike - that did the trick.

"Mike H" wrote:

Monica

Multiply by 10?

Sub lime()
Set myrange = Range("A1:A10")
For Each c In myrange
c.Value = c.Value * 10
Next
End Sub

Mike

"Monica" wrote:

Trying to create a macro to add a zero to the end of a cell or range of cells
-

Ie - if number is 123 it becomes 1230

Thanks

All times are GMT +1. The time now is 12:23 AM.