Monday, December 14, 2009

Excel Cell Formating

Today I would like to present you some tips on excel formatting;

1. Formatting an excel cell to Text, Number, Date
, Time, Currency, Accounting, special or custom.

Select any excel cell and then on the menu click on Format then click
on cell you can also use shortcut to open the cell formatting box directly
by holding Ctrl+1 key, as shown in the following figure.

Image and video hosting by TinyPic

   As in the above figure
you can see Category box from where you can change the cell format to your
desired format. You can do lot more than format in an excel cell. Make
your excel cell a digital clock or digital image viewer, whatever you want
just imagine and do it by using all the advanced features of cell
formatting  to know more about how to do it just give a comment to
this post.