Hi! I can not seem to figure out how to do the following:

I have a spreadsheet template which is populated by a 3rd party data source.
One of the columns gets data in this format: 12345678. My users prefer
seeing it in Millions rounded: 12.3(M).

Is there a way I can program a formula to make this rounding automatic upon
population? I do not see any functions to help me do that.

Any ideas are greatly appreciated.

Thank you in advance,