Rounding data entered as Millions, how to please
 

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,

Rounding data entered as Millions, how to please
 

Custom format cell as

#,##0.0,,

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568526

Rounding data entered as Millions, how to please
 

Try formatting the cell as custom:

#,###.0,,"(M)"_);(#,###.0,,"(M)";0.0"(M)"_)
--
Gary's Student


"Mike" wrote:

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,

Rounding data entered as Millions, how to please
 

Don 't forget the "(M)"

--

HTH

Bob Phillips

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

"VBA Noob" wrote in
message ...

Custom format cell as

#,##0.0,,

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile:
http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=568526