S Sara Member Nov 11, 2013 #1 Hi there In excel 2007, what do I write if I want to create the custom format to change this $1,200.00 to $1.2 K, but also takes $600.00 and changes to $0.6 K? If I write this $#, K the result is rounded, so both examples above show as $1 K. Cheers Sara
Hi there In excel 2007, what do I write if I want to create the custom format to change this $1,200.00 to $1.2 K, but also takes $600.00 and changes to $0.6 K? If I write this $#, K the result is rounded, so both examples above show as $1 K. Cheers Sara
N NARAYANK991 Excel Ninja Nov 11, 2013 #2 Hi Sara , Introduce a decimal place in the format , thus : $#.#0, K Narayan
