Actually, if all the numbers included a decimal point and a tenths digit, then I
just screwed up my number of 0's.

123000 would have to be displayed as 123.0K for this to work:


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

edit|Replace
what: K
with: 00
replace all

edit|Replace
what: M
with: 00000
replace all

Fred Smith wrote:

This works fine if there are no decimals, but would change 123.4K to 1234000,
not 123400.

--
Regards,
Fred

"Dave Peterson" wrote in message
...
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

--

Dave Peterson