ExcelBanter - Seperate with space

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

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

- - Seperate with space (https://www.excelbanter.com/excel-programming/290275-seperate-space.html)

Pat

Seperate with space

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

Eloy

Seperate with space

place a space before the S inside the quote

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

All times are GMT +1. The time now is 07:42 AM.