Question

what is the use of different number formats​

Answer 1

You can apply different formats to numbers to change how they appear. The formats only change how the numbers are displayed and don't affect the values. For example, if you want a number to show as currency, you'd click the cell with the number value > Currency.

Answer 2

ANSWER:

Available number format in excel:-

In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers or social security numbers.

Number format:-

Applying a number format only changes know the number is displayed and doesn't affect cell values actual value in the formula bar.

follow me