Knowledge and tips for Excel cell custom formats

knowledge and tips for Excel cell custom formats

Here is a brief introduction to Excel cell custom format knowledge and skills.

1, "g/General format"

appears as a regular number, equivalent to the General option in the category list.

Code: g/Common format. 10 Display as 10;10.1 display as 10.1

2, "#": Digit placeholder

Only meaningful 0 does not show insignificant 0. The number of digits after the decimal point that is greater than "#" is rounded by the number of digits of "#".

Code: ###.##. 12.1 Displays as 12.1, 12.1263 shows as 12.13

3, "0": Digit placeholder

If the contents of the cell are greater than the placeholder, the actual number is displayed, and 0 is made up if the number of points is less than the bit character.

For example code: 00000. 1234567 displays as 1234567, 123 shows as 00123

Code: 00.000. 100.14 displays as 100.140, 1.1 shows as 01.100

4, "@": Text placeholder

If you use only a single @, the effect is to refer to the original text, to automatically add text after you enter numeric data, use the custom format: text content @; To automatically add text before entering numeric data, use the custom format: @ text content. The position of the @ symbol determines the position of the numeric data entered by Excel relative to the added text. If you use more than one @, you can repeat the text.

code:;;; " Group "@" department. Financial display as group Finance Department