Excel Number Format Archives

Zip Code in Excel (Insert, Display, Format & Remove)

Dec 21, 2023

In this article, you will learn the process of formatting zip codes in Excel. This includes the application of ready-made postal code formats or the ...

Zip Code in Excel (Insert, Display, Format & Remove)

Custom Number Format in Excel (13 Unique Examples)

Dec 21, 2023

In this article, you will learn how to create a custom number format in Excel with proper illustrations and examples. Custom number formats in ...

Custom Number Format in Excel (13 Unique Examples)

How to Pad Zeros in Excel? (Complete Guideline)

Dec 21, 2023

In this Excel tutorial, you will learn how to pad zeros in Excel. We will use different Excel functions (TEXT, TEXTJOIN, CONCATENATE, REPT, BASE, and ...

How to Pad Zeros in Excel? (Complete Guideline)

Excel Date Format (Learn and Convert)

Dec 21, 2023

In this article, you will find various tasks related to date conversion, formatting, and manipulation in Excel. It also includes converting different ...

Excel Accounting Number Format (Apply and Customize)

Dec 21, 2023

Using the Accounting Number Format in Excel is easy and can be done in a variety of ways. You will learn to apply accounting number format in ...

Excel Accounting Number Format (Apply and Customize)

Currency Format in Excel (Format, Change & Remove)

Dec 21, 2023

Currency format in Excel allows you to present numbers as currency amounts, complete with currency symbol, decimal precision and many other ...

Currency Format in Excel (Format, Change & Remove)

Excel Scientific Notation (All Things You Need to Know)

Dec 26, 2023

In this article, you’ll learn how to add Excel scientific notation using the scientific format, the Format Cells option and the manual process. ...

Excel Scientific Notation (All Things You Need to Know)

Fraction in Excel (Write, Display and Convert)

Dec 21, 2023

In this article, you'll learn everything one should know about fractions in Excel. This article covers how to write fractions, convert them, and ...

Fraction in Excel (Write, Display and Convert)

Decimals in Excel (Add, Remove)

Dec 21, 2023

In this article, we will discuss how to add and remove decimals in Excel. Decimals are commonly in use while dealing with currency, accounting, ...

Negative Number in Excel (Add, Format, and Convert)

Dec 21, 2023

In this article, we will learn how to add a negative number in Excel. We will also learn how to format a negative number and even convert negative ...

Negative Number in Excel (Add, Format, and Convert)

How to Change Number Format in Excel

Feb 11, 2024

Change Number Format in Excel: Knowledge Hub How to Convert European Number Format to US in Excel How to Convert Percentage to Decimal in ...

Number Format Is Not Working in Excel (2 Reasons with Solutions)

Dec 20, 2023

Microsoft Excel is considered one of the most valuable tools currently accessible. With Excel's tools and capabilities, it is feasible to perform an ...

Number Format Is Not Working in Excel (2 Reasons with Solutions)

How to Format Complex Numbers in Excel (4 Easy Methods)

Dec 20, 2023

Complex numbers are expressed as a+ib, where “a” is a real part of the complex number and “b” is an imaginary part of the complex number. For ...

How to Format Complex Numbers in Excel (4 Easy Methods)

How to Enter 20 Digit Number in Excel (2 Easy Methods)

Dec 20, 2023

If you are searching for solutions or some special tricks to enter 20 digit number in Excel then you have landed in the right place. There are 2 ways ...

How to Enter 20 Digit Number in Excel (2 Easy Methods)

How to Enter 16 Digit Number in Excel (3 Simple Ways)

Dec 20, 2023

Microsoft Excel is used to store data in a tabular format and to perform calculations on that data. We might need to input data with 16 digit number. ...