How can the format of the building number be the same when the property fee is exported?

Fill in the data of each unit. For example, the cell data population value "=sheet 1". B3, the filling value of "BuildingNo." is "=sheet 1. C3, etc. Fill in all available data. Note: The filling data of "cell" is the cell data of "building house number" entered in the following functional formula "= left (b3 b3,5)". Then pull down batch filling in a unified way.

Create another worksheet in the workbook, which can be named "Print by Company". Do a good job in the first line and write down the notice instructions such as the time and place of payment that need to be explained to the residents. The font format can be bolded with ì 18, and then enter the project names such as "community name, building number, unit, charging ratio, heating fee receivable" in the second line.

The format, Chinese characters and pinyin are géshì, which means the rules and regulations of officials. Certain specifications.