remove comma in column

[marreco]

Hi.
I have a worksheet named 'Data' and column 'E' that has followed. values

ID	name	Value1	Value2	number
123	Alex	54	65	500,25
354	Mark	21	54	500,00
415	Joe	12	32	502,25
875	Bill	65	74	500,50

<tbody>
</tbody>

I want the last column (number), was well formatted.


50025
50000
50225
50225
60000
50050
I tried a code made by VOG, but I can not adapt it

Sub test()
With Worksheets("Dados").UsedRange
    .Replace what:=",", replacement:="", Lookat:=xlPart
    .NumberFormat = "00"
End With
End Sub

thank you!!

 

[TheCman81]

You need to change the name of the sheet in the above code "Dados" to whatever the name of your sheets is which I assume "Data"

so the code would be:

Sub test()
With Worksheets("Data").UsedRange
    .Replace what:=",", replacement:="", Lookat:=xlPart
    .NumberFormat = "00"
End With
End Sub

 

[marreco]

Hi.
still does not solve my problem
thank you!!

 

[Domski]

Are you able to replace the commas by doing a find...replace manually?

Dom

 

[marreco]

Hi
My original spreadsheet has 10000 rows

 

[Domski]

I didn't mean by editing the cells yourself. I mean by pressing Ctrl+H and replacing , with nothing.

I'm trying to ascertain whether the commas are there as part of a text string or because the numbers are formatted that way.

Dom

 

[marreco]

there are ways to do the way I need?

 

[Domski]

Should I assume English isn't your first language? Do you understand what I'm asking in my previous post?

Dom

 

[marreco]

Hi.
I'm sorry I did not understand.


there is a way to do this for VBA

 

[marreco]

Hi.
I'm sorry I did not understand.


there is a way to do this for VBA