How would I make a macro in Excel to delete all text in a range?

Does anyone know how to delete all text within a cell range or a single character at the end?
The cells in question look a little something like this:
12.2k
1,029
41.6k
9,085k

Now all I need to do is to get rid of the "k" to make it numeric data using a macro.
4 answers 4