Forum Discussion
macro VBA excel change cell format
Hello! In my macro, I used code to replace "." on ",". However, during this replacement, the cell format changes to text. How can I write code to ensure that the format remains as a number? S...
The values in columns Z to AC have spaces before the numbers. Why is that?
- Because this data is inserted from another file. Then I wanted the button to change "." on ","
Try this:
Sub change() Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart Selection.Replace What:=" ", Replacement:="", LookAt:=xlPart End Sub- The same thing