Thursday, November 21

Number Formats In Excel

Definition:- The Number Format Is A Special Code To Control How Values Are Displayed In Excel. Number Formats Change The Way Numeric Values Are Displayed. But They Do Not Change Actual Values.

GeneralGeneral Option Is The Default Option Applied By Excel For Any Value Number Or Text Format

1. Number:- Number Option Is Used For General Display Of Numbers. The Decimal Number Decimal Can Be Specified. if Want To Display Negative Numbers In Different Formats.


2. Currency:- The Currency Option Can Be Used To Specify Any International Currency Symbol With Numbers. And Also To Specify The Decimal Number.


3. Accounting:- Accounting Option Similar To Currency Option. The Accounting Option Can Set The Currency Symbols And Decimals Together.


4. Date:- With Date Option The Date Can Be Displayed In The Desired Format From The Various Available Formats As Shown Below In The Example.


5. Time:- With Time Option The Time Can Be Displayed In The Desired Format From The Various Available Formats As Shown Below In The Example.


6. Percentage:- The Percentage Option Multiplies The Value Of The Cell By 100 And Returns The Result With The Percent (%) Symbol As Shown Below In The Example.

Leave a Reply

Your email address will not be published. Required fields are marked *