Hi Forum!

I have the following problem, a column of cells with numbers with the following format: 4 000 000 displayed as 4MM, and 4 billion displayed as 4MMM.

I would like all MMs to be deleted, so that the data is millions, and the MMM deleted and the number multiplied by 1000, So that the macro will run down my column and change:

400MM to 400
4MM to 4
1.5MMM to 1500
etc

Any ideas?

Thanks