View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Monica Monica is offline
external usenet poster
 
Posts: 37
Default How do I create a macro to add a zero to end of a cell? or cel

Gary-

What if they are not all integers - example:

1113-456 (and I need to add a zero at the end) to make it 1113-4560 (the
dash needs to stay).

Thanks!!!!

"Gary''s Student" wrote:

If all the numbers in the range are integers then:

Sub monica()
For Each r In Selection
r.Value = 10 * r.Value
Next
End Sub

--
Gary''s Student - gsnu200737


"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