Guys,
i have a simple code:
The goal is to change the regional settings. I want to get rid of "," which means decimal places in my region.
Unfortunatelly this is not working![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
IN the cells there are just values with general format like 7,100. After macro it should be 7100.
I run Ctrl+H manualy and this is working. Once in macro - it doesn't![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
pls support
i have a simple code:
Code:
With Rows("3")
.Replace What:=",", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=True, SearchFormat:=False, _
ReplaceFormat:=False
End With
![icon.png](https://www.mrexcel.com/forum/moz-extension://840c642a-77f7-4bc6-9404-1c1706b87adb/icons/icon.png)
The goal is to change the regional settings. I want to get rid of "," which means decimal places in my region.
Unfortunatelly this is not working
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
IN the cells there are just values with general format like 7,100. After macro it should be 7100.
I run Ctrl+H manualy and this is working. Once in macro - it doesn't
![Frown :( :(](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f641.png)
pls support