Thread: Seperate with space
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Eloy Eloy is offline
external usenet poster
  
Posts: 3
Default 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
Reply With QuoteReply With Quote