Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Formatting Numbers > Useful Number Functions< Previous | Next > 


 

Removing Decimal Places

 
 

=TRUNC(12.345)=12

 

 

Obtaining the Absolute Value

 
 

=ABS(-10)=10

 

 

Obtaining a certain number of decimal places

 
 

=ROUND(12.3456,2)=12.35

 







 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >