How Excel sets the million-bit separator

First, select the cells you want to set, and then perform the menu action: Format → cell, pop-up dialog box.

Select the Number tab in the dialog box, and then find "custom" in the category; At this point, a type of input box will appear on the right, and now, just enter the format inside to complete the setup.

①-Type Universal separator

In the Type input box, enter 0!. #, you can.

This format, displayed as: 123896575 will display a different 12389.7 display, but the value has not changed.

②-Type Universal separator

In the Type input box, enter the [>100000000]#!,####!,####.00; [>10000]#!,####.00;#.00 can be.

This format, shown as: 78965235 will appear as 7896,5235.00

③-Type Universal separator

In the Type input box, enter 000,000.00.

This format, shown as: 7896452345 will appear as 7,896,452,345.00