How can I change $20.0m format to $20.0 million format, can I do this with GREP
Yes, you can use GREP
Find (\d\.\d+)m (this allows for the possibility that there might be more than one digit after the decimal point)
Change $1<space>million (<space> is a press of the spacebar).
Thanks very much that did the trick beautifully.
Retrieving data ...