Rounding data entered as Millions, how to please

[Guest]

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,

 

[VBA Noob]

Custom format cell as

#,##0.0,,

VBA Noob

 

[Guest]

Try formatting the cell as custom:

#,###.0,,"(M)"_);(#,###.0,,"(M)";0.0"(M)"_)

 

[Bob Phillips]

Don 't forget the "(M)"

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)