Format a Number Using the Format Cells Dialog Box : Value Format « Editing « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Editing
3. Value Format

Select a cell or a range. 
           Click the Home tab. 
           Click the Number Dialog Box Launcher.

Click to select a category. 
           Select the options. Preview your selections in the Sample box. Click OK.

Check the result

2.15.Value Format
	2.15.1.	Format Values as Number
	2.15.2.	Format Values as Currency
	2.15.3.	Format Values as Long Date
	2.15.4.	Format Numbers
	2.15.5.	Format Currency
	2.15.6.	Short Date Format
	2.15.7.	Long Date Format
	2.15.8.	Percentage Format
	2.15.9.	Scientific Format
	2.15.10.	Format a Number Using the Format Cells Dialog Box
	2.15.11.	To create a custom number format using the Format Cells Dialog Box
	2.15.12.	Format numbers in international currencies
	2.15.13.	Remove a numeric format or font attribute