How to display a calcd field as 18.5 (million)iv 18,495,678
 

--
dbutcher

How to display a calcd field as 18.5 (million)iv 18,495,678
 

Hi,
Go to format cell, number, custom and enter this

0.000,, "M"

if this help please click yes, thanks

"Deb" wrote:


--
dbutcher

How to display a calcd field as 18.5 (million)iv 18,495,678
 

Hi,
the answer given before is with 3 decimals for only one use

0.0,, "M"

"Deb" wrote:


--
dbutcher