Excel custom format (1)

Excel2010 has many built-in cell formats, which basically cover common formats of numbers and text representation. But in some cases, it still cannot meet my needs, so Excel also provides us with a custom format function. Before getting started, let's take a look at an example. Column C is the name of the company's internal user we export from a certain application, but this system does not store the user's email address, what should we do if we want to display their emails in our own reports? Of course, there is a way to directly enter it. Just enter the D2 cell. However, if there are thousands of user names, it would be a waste of time to enter them. As you can think of, the mail address is the same in every cell after @, so that we can use a custom format to define all the characters After @ as the cell format, @ gamesacorp.com is automatically added no matter what content is entered in this cell.

650) This. width = 650; "Title =" 122.jpg" src = "http://s3.51cto.com/wyfs02/M01/47/F8/wKioL1QFKxmxYvsSAACDbxEaHyU649.jpg" width = "265" Height = "223" alt = "wkiol1qfkxmxyvssaacdbxeahyu649.jpg"/>

First, let's make the content of column D equal to column C,

650) This. width = 650; "style =" width: 304px; Height: 220px; "Title =" 125.jpg" src = "http://s3.51cto.com/wyfs02/M02/47/F7/wKiom1QFLmLAqKxRAACiP4cIuSg154.jpg" width = "303" Height = "340" alt = "wkiom1qflmlaqkxraacip4ciusg154.jpg"/>

Then, select the cell with the suffix of the email address to set the custom format. As you can see, the custom format is @ "@ gamesacorp.com". The front @ is a text placeholder.

650) This. width = 650; "Title =" 126.jpg" src = "http://s3.51cto.com/wyfs02/M00/47/F7/wKiom1QFLq6Q_9_QAAIHrnj2E6A502.jpg" width = "301" Height = "299" alt = "wkiom1qflq6q_9_qaaihrnj2e6a502.jpg"/> 650) This. width = 650; "style =" width: pixel PX; Height: 304px; "Title =" 124.jpg" src = "http://s3.51cto.com/wyfs02/M02/47/F9/wKioL1QFLs6CQBJIAADE77sBsME006.jpg" width = "235" Height = "250" alt = "wkiol1qfls6cqbjiaade77sbsme006.jpg"/>

Apply the effect after the custom format.

650) This. width = 650; "Title =" 127.jpg" src = "http://s3.51cto.com/wyfs02/M00/47/F9/wKioL1QFLyqxE_boAAD4eQ3J3nE345.jpg" width = "344" Height = "217" alt = "wkiol1qflyqxe_boaad4eq3j3ne345.jpg"/>

This is very efficient.

Let's look at another example of adding numbers to units. D2 to D3 is the correct result, but D4 to d6 does not get the correct result. The formula bar of cell B5 is = 4"

650) This. width = 650; "Title =" 128.jpg" src = "http://s3.51cto.com/wyfs02/M01/47/FA/wKioL1QFMhWjToBlAACNKbVvFPo588.jpg" width = "363" Height = "178" alt = "wkiol11_mhwjtoblacbvvfpo588.jpg"/>

The content in cell B2 is the value 1.

650) This. width = 650; "Title =" 130.jpg" src = "http://s3.51cto.com/wyfs02/M01/47/F8/wKiom1QFMuzRHr2nAACBscZw0hQ953.jpg" width = "365" Height = "212" alt = "wkiom1?muzrhr2naacbsczw0hq953.jpg"/>

What is the difference? B5 uses the hyphen & to produce text. B1 uses a custom format. Enter 0 "items". 0 is a digit placeholder.

650) This. width = 650; "style =" width: 384px; Height: 350px; "Title =" 129.jpg" src = "http://s3.51cto.com/wyfs02/M01/47/FA/wKioL1QFM1KSzNfUAADYN3U_LXU538.jpg" width = "356" Height = "340" alt = "wkiol1qfm1ksznfuaadyn3u_lxu538.jpg"/>

In this example, the custom format looks like a vest. Put the value in the cell on the "vest" or that value. The property type does not change.

 

This article ends with two examples to introduce the custom format. Next, we will introduce more meanings of special symbols in custom formats.

 

 

This article from the "GUO Yong technology blog" blog, please be sure to keep this source http://guoyong.blog.51cto.com/408495/1547740

Excel custom format (1)