Number formats control how a value is displayed without changing its real value: number, currency, percentage, date, time, text. The format does not alter the cell's content as used in calculations. A number stored as text cannot be calculated.
Example
The value 0,256 displayed in percentage format becomes 25,6 %, but remains 0,256 in calculations.