convert numbers with K and M
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
|