FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -If you specify only one section of format code, the code in that section is used for all numbers. If you specify two sections of format code, the first section of code is used for positive numbers and zeros, and the second section of code is used for negative numbers.

Detailed explanation-2: -A number format can have up to four sections of code, separated by semicolons. These code sections define the format for positive numbers, negative numbers, zero values, and text, in that order. You do not have to include all code sections in your custom number format.

Detailed explanation-3: -By default, all cells in Microsoft Excel worksheets are formatted with the General format. With the default formatting, anything you input into a cell is usually left as-is and displayed as typed.

Detailed explanation-4: -In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers. Play. Select a cell or a cell range. On the Home tab, select Number from the drop-down.

Detailed explanation-5: -Also, the Currency format is the only general currency format. Still, the Accounting number format is the proper Currency format with the option to have decimal values, which are two by default.