Question

define number format in excel​

Answer 1

The number format does not affect the cell value that Excel uses to perform calculations. The actual value is displayed in the formula bar. Excel provides several built-in number formats. You can use these built-in formats as is, or you can use them as a basis for creating your own custom number formats.