Increase Decimal

Post author:Neale Blackwood
Post published:20/04/2017
Post comments:2 Comments
Reading time:1 min read

I found a good shortcut today to increase the decimal places.

Alt H 0

For example you might use these two shortcuts one after the other to format a range as a percentage with one decimal place.

Ctrl + Shift + %

Alt H 0


Related Posts

					
			
				Getting the Right Quotation Marks in Word
			
					
			
				Highlight Excel Formulas
			
					
			
				Excel Drop-downs and Wildcards
			
					
			
				Custom Number Format Tip: Add a Line Break in a Cell
			
					
			
				Ensure a Single Check Box Selection

This Post Has 2 Comments

Nirupa 17/05/2017 Reply

Very useful tip Neil. In order to decrease the Decimal we need to use 9… Thank you.
1. Neale Blackwood 17/05/2017 Reply
  
  You are welcome Nirupa

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.