Question

does the number format effects the value of cell.​

Answer 1

Answer:

Formatting a number does not affect the actual value (in the cell) but just changes how the value is displayed. Any formulas will always use the actual value and not the value that is displayed. The actual value stored in a cell is the value used in your formulas and is not the value that is displayed.

Answer 2

Answer:

$Formatting a number does not affect the actual value (in the cell) but just changes how the value is displayed. Any formulas will always use the actual value and notthe value that is displayed. The actual value stored in a cell is the value used in your formulas and is not the value that is displayed.}$