Seperate with space

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Could someone help me place a space between the
number and the letter S

Private Sub Increment_Click()
With Me.Range("K20")
..Value = .Value + 1
..NumberFormat = "00000""S"""

thanks
Pat
 
place a space before the S inside the quote

Sub test(
With Range("K20"
.Value = .Value +
.NumberFormat = "00000"" S""
End Wit
End Sub
 
Back
Top