I would do a few Edit|Replaces.

Select the range to fix
edit|Replace
what: . (decimal point)
with: (leave blank)
replace all

edit|Replace
what: K
with: 000
replace all

edit|Replace
what: M
with: 000000
replace all

Then format them the way I want.


bbs wrote:

I have a column of text that represent numbers which have been abbreviated
with K (for thousands) and M (for millions). (e.g. 123400 is displayed as
123.4K, 123456000 is displayed as 123.456M) How can I convert these to
numbers?

--

Dave Peterson