#Custom formatting excel text how to#
#Custom formatting excel text code#

You want to change the column as the вЂAfter sectionвЂ™. Suppose you have a weight record of children and it looks like below: Lea rn Excel Keyboard shortcuts from this online excel course 5. Remember one thing is just the format and the length of the character does not change. Notice as soon as you type six zeroes, in the preview, you can see it has added two zeroes before the numbers. Now go to custom in general type six (6) zeroes.So the trick is to choose all the cells and press ctrl +1 to get the format cell dialog box.And if you do so you will not be able to apply any functions on these cells. But the zeroes will go away until and unless you change the format of the cells as text. Now the point is how you will format cells in excel so that total digit should look like a six-digit code.

For example, you have data like below (before).

#Custom formatting excel text how to#

Now I will tell you how to add prefix вЂњ00вЂќ for a check number. And then click on OK.ДЄs you press ok you get the benefit of both prefix Rs. You will notice in the preview section Rs.

#Custom formatting excel text code#

Now before the starting of the custom code put вЂњ Rs. You will find a long list of custom codes that signifies comma separator should be with the million and lakhs. So what will be my approach? To apply this you need to go to the home tab then apply the comma separator, reduce one decimal and then press ctrl +1 and press custom. Notice these are numbers with one decimal but I donвЂ™t find any comma-separated-values, the way you have in million and lakhs. This ensures that numbers are there with one decimal.ДЄs soon as you click on ok you will find that numbers are formatted with Rs. Now I am going to custom format in excel and then type вЂњRs.вЂќ 0.0.Select your range and then press Ctrl +1.Now from the above picture, it is clear what my raw data is and what I actually want.

If you know this trick then you do not have to do this manually. If I enter any amount in this column I will need to add Rs. I can easily do it by typing it manually but then I will not be able to apply any function. in my records so that I can apply sum, average, min, max function. You can also change the width of the column. If you want to test then delete a few letters from a clientвЂ™s name and then check.

Then go to custom and in place of general type As soon as you will press ok you will see the trailing dots are added and it is self-adjusted.

You can select the entire column and then press Ctrl +1 and dialog box format cells in excel will open.

Select your range where you want to put dots (.).

You may have questions running in your mind regarding this technique of formatting cells in excel вЂ“ How will we achieve this? вЂ“ Will we go ahead and manually put dots (.)? вЂ“ What will happen if I delete a few letters from a clientвЂ™s name? вЂ“ Will it be self-adjusted? I have the list of client names and I want to add dots (.) so that it looks good. I want to add dots (.) so that it looks good and is also self-adjusting. For example, you have a list of names of your clients. Here I will talk about how to format cells in excel with trailing dots. Remember, the shortcut key is Ctrl + Shift + 3 to format a date as a dd-mmm-yyyy format. Now your date is properly formatted with one shortcut key. Select your range and then press Ctrl+ Shift + 3. Besides this, there is also another trick if you want to show your date as dd-mmm-yyyy format. Now you have your date as per your required date format.

Then select date category and then choose your Date format from the selection pane at the right.

So after selecting the range just press ctrl+ 1.

Simply press ctrl +1 to format cells in excel. Then we right-click and then click on Format cell in excel.

Normally what we do is, we select the entire range of cells. So that it can show the date format like, which is easy to read. Date Format:ДЇor example, you have a long set of dates in cells like below:ДЄnd you want to change the date format as a dd-mm-yyyy format. LetвЂ™s discuss 5 Tricks to Format Cells Data in Excel: 1. There are mainly 5 different types of cells data format as follows: These excel tricks & tips are covered in detail in our video-based advanced Excel Training on our online school for professionals. Almost all Microsoft Excel users know how to change the date format, numbers, and text formats using rows and columns.Д«ut very few know how efficiently and quickly customize it to suit your requirements. Applying these in excel will make your worksheet or spreadsheets look attractive and easy to read. In this article, you will learn 5 Excel tricks on how to format cells in Excel.