G Guest Feb 16, 2007 #1 Does anyone know how to format the following examples as shown? $6,545,000 to $6.5M $6,545 to $6.5K
D Dave Peterson Feb 16, 2007 #2 Maybe... [>999999]$#.0,,"M";$#.0,"K" Does anyone know how to format the following examples as shown? $6,545,000 to $6.5M $6,545 to $6.5K Click to expand...
Maybe... [>999999]$#.0,,"M";$#.0,"K" Does anyone know how to format the following examples as shown? $6,545,000 to $6.5M $6,545 to $6.5K Click to expand...
G Guest Feb 16, 2007 #3 That worked! Thank you. -- Rob Dave Peterson said: Maybe... [>999999]$#.0,,"M";$#.0,"K" Click to expand...
That worked! Thank you. -- Rob Dave Peterson said: Maybe... [>999999]$#.0,,"M";$#.0,"K" Click to expand...