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: -Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells…, and select Number.

Detailed explanation-3: -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-4: -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-5: -Whenever you’re working with a spreadsheet, it’s a good idea to use appropriate number formats for your data. Number formats tell your spreadsheet exactly what type of data you’re using, like percentages (%), currency ($), times, dates, and so on. Watch the video below to learn more about number formats in Excel.