Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-20-2017, 06:59 AM
gebobs gebobs is offline Data label precision Windows 7 64bit Data label precision Office 2010 64bit
Expert
Data label precision
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Data label precision Sum scattered data with same label pfarrelli Excel 3 12-28-2016 02:07 PM
Pie chart showing more than one data label chickasaw Excel 2 03-10-2015 07:27 PM
Can't move objects with precision MLF PowerPoint 3 07-31-2014 04:03 AM
Display a label character in a data cell markg2 Excel 9 09-07-2013 05:56 AM
Trying to merge label data from file ClayShannon Mail Merge 0 09-16-2009 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft