I was using the recorder to record this with the find and replace feature,
but it is the replace text I am having trouble with.

"Bob I" wrote in message
...
Tools, Macro, Record New macro

Melissa wrote:

I am using the wildcards feature in find and replace to find the last 6
digits of numbers over 1 million. - [1-9]{6}

How would I go about telling the replace field to insert a period in the
front of the text, skipping over two numbers, trimm off the rest, insert
a
space and then the word "million"?

For example:

Find 1684232 - ([1-9]{6})
Replace with 1.68 million