Converting numbers with K to 1000's

[Thresh1642]

Hi,

I have a list of values that I need converted.
They look like this:

14.75K

29K

44.5K

26.5K

28.5K

1.5K

22K

<tbody>
</tbody>

and I am trying to get them changed to

14750

29000

44500

26500

28500

1500

22000

<tbody>
</tbody>

Any and all help Appreciated!

Thanks,
Todd

 

[shg]

Select the column and replace K with e3

 

[Thresh1642]

Thanks SHG!

 

[shg]

You're welcome.