Excel Tricks with Tejraj

We have seen previously in brief about how we can “ Format Cell Values in Excel ”. In that blog post we have learned about converting cell values in various formats but in a brief way but now ee will focus on “Accounting Format in Excel” in this blog post. In our previous blog post we have seen 03 methods to go to additional options of formatting cell values. If you missed to read those methods, please click here before going for this blog post. We can use any of these 03 methods to get the “Format Cells” dialog box and select “Accounting” Category as shown in below image. With this we can see all the additional options under Accounting Formats in excel. The additional options which we can see under “Accounting Format” are shown in below image: Sample : This option is common in all the formats which we can see under Category in above image which we can use to see how the selected numbers will look in accounting format. Decimal Places : With this we can increase or decrease the decim...

In this blog post we will learn to “Format Cell Values” in excel. Many times while working in excel we have to use various formats like text, number, date etc. to our cells values. So here we will learn how to format our cells and how many formats are there which we can use to our cell values. First of all we will see where these various formats are available on our excel screen. For this we have to click on “Home” tab and check the “Number” group. If we click on the drop down menu as shown in below image we can see all the formats which we can use to format our cells. We will see all these formats in brief in this blog post. To change the format of a cell values, first select the respective cell and then select the desired format from the below image as per your requirement. General Format: By default “General” format is applied to excel cells. It means there is no any specific number format is applied to the cells. Number Format:  This format is used to display the numbers. For e...