Nlhicks
Active Member
- Joined
- Jan 8, 2021
- Messages
- 264
- Office Version
- 365
- Platform
- Windows
VBA Code:
With wksWork
.Range("B32").Value = .Range("H28") & " " & .Range("J13")
.Range("D32").Value = ("(" & .Range("L11") & " " & .Range("K13") & " " & .Range("L13") & " " & .Range("Q13") & " " & _
"," & .Range("O11") & " " & .Range("N13") & " " & Range("O13") & " " & .Range("Q13") & ")")
This code work but my formatting in cells K13 and O13 are a number limited to 2 decimal places but when I concatenate the data it is giving me this in the table:
How can I make it only go up to 2 decimal places like the format?