Excel tutorials automatically add units, prefix formatting methods

This tutorial is for you to solve this problem, in the format of the number cell: Add the format of the unit after the number, and add the format of the identifier before the number.

① start Excel2007, select the E2:e9 range, and click the menu bar-start-format-to format the cells.

② The Format Cell Formatting dialog box, select Custom in the category, and then add a "piece" word after the type.

③ this adds units to the Quantity column, selects the F2:f9 area, and clicks the menu bar-format-to format the cells.

④ is still in the category-customization of the modified type, add a set of double quotes, quotation marks inside the RMB, to express the meaning of the renminbi.

⑤ complete, we look, e column number and F column Unit price, all add the unit, prefix, so that users can easily understand the meaning of the form expressed.

        Note: More wonderful tutorials Please pay attention to the Triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join