Friday, April 1, 2011

Change Data Format In Microsoft Excel

In Microsoft Excel we have the default format as number. But in order to get any other format like time or data format we need to change it. Microsoft Excel has many formats which help us in assisting the data manipulation or processing easier. 

Steps to change the format of data of whole worksheet

1) Click on top left corner of Rows and Columns

2) Click on Format Menu and Click on Cells.

3) we will get  dialog box where we have all the formats available with the Office suite we have installed.

Click on a category to get the format applied to whole worksheet.


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More