Increase Decimal | A4 Accounting

Increase Decimal

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

					
			
				Double Click the Excel Icon
			
					
			
				Clear all formats
			
					
			
				Drop Down Selection update
			
					
			
				Excel Has Ordinals
			
					
			
				Restarting Excel and Windows

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply Cancel reply

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

2 thoughts on “Increase Decimal”

Nirupa says:

17/05/2017 at 10:44 am

Very useful tip Neil. In order to decrease the Decimal we need to use 9… Thank you.

Reply
- Neale Blackwood says:
  
  17/05/2017 at 11:10 am
  
  You are welcome Nirupa
  
  Reply