View Single Post
 
Old 06-20-2017, 06:59 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default Data label precision

I use the format [>=1000]#,##0,"K";General to display data labels using a K to denote thousands.

This makes something like 1,457,735 appear as 1,458K. Simple enough.

Is there a way to reduce the precision to perhaps three significant figures i.e. 1,460k?
Reply With Quote