A setting that controls how a cell's value appears visually without altering the underlying data.
AI로 사용해 보기Number formatting changes the appearance of numbers, dates, or currencies by adding symbols, decimal places, or separators. It is purely cosmetic, meaning Excel continues to use the original, unformatted value for all calculations.
Applying the 'Currency' format to the number 1234.5 displays it as '$1,234.50', but the cell still holds the value 1234.5 for math operations.
No, Excel uses the underlying stored value for calculations, regardless of how it is displayed.