Propertunity 14th Nov, 2011 #1 having a brain overheat, in Excel: How do you make $1,000,000 appear as $1.0M ? ...and $1,100,000 as $1.10M please.
having a brain overheat, in Excel: How do you make $1,000,000 appear as $1.0M ? ...and $1,100,000 as $1.10M please.
R Rooster 14th Nov, 2011 #4 Propertunity said: I think I could live with that. What's $5K between friends? Click to expand... Try: [>100000]$#.00,,"M" Custom format. Cheers Rooster
Propertunity said: I think I could live with that. What's $5K between friends? Click to expand... Try: [>100000]$#.00,,"M" Custom format. Cheers Rooster