Converting numbers with K to 1000's

[Thresh1642]

Hi,

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]14.75K[/TD]
[/TR]
[TR]
[TD]29K[/TD]
[/TR]
[TR]
[TD]44.5K[/TD]
[/TR]
[TR]
[TD]26.5K[/TD]
[/TR]
[TR]
[TD]28.5K[/TD]
[/TR]
[TR]
[TD]1.5K[/TD]
[/TR]
[TR]
[TD]22K[/TD]
[/TR]
</tbody>[/TABLE]

and I am trying to get them changed to

[TABLE="width: 500"]
<tbody>[TR]
[TD]14750[/TD]
[/TR]
[TR]
[TD]29000[/TD]
[/TR]
[TR]
[TD]44500[/TD]
[/TR]
[TR]
[TD]26500[/TD]
[/TR]
[TR]
[TD]28500[/TD]
[/TR]
[TR]
[TD]1500[/TD]
[/TR]
[TR]
[TD]22000[/TD]
[/TR]
</tbody>[/TABLE]

Any and all help Appreciated!

Thanks,
Todd

 

[shg]

Select the column and replace K with e3

 

[Thresh1642]

Thanks SHG!

 

[shg]

You're welcome.