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

 

Step 1 - Understanding the Format

 
 

This is exactly the same as the general format except that you can also select a currency symbol to precede (or succeed) the value.

 
   
 

Decimal places - The number of decimal places is from 0 to 30

 
 

Symbol - There are over 350 possible currency symbols to choose.

 
 

Negative Numbers -

 
 

The thousand separator is always displayed.

 

 

Step 2 - All Numbers in Black

 
 

Default currency button on the toolbar ??

 
   

 

Step 3 - Negative Numbers in Red

 

   

 

Step 4 - Negative Numbers in Parentheses

 

   

 

Step 5 - Negative Numbers in Red with Parentheses

 

   

 

Step 6 - Things to Remember

 


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