Excel Number Format Archives

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

Jul 30, 2024

We'll cover a common scenario where we might need to remove the last 4 digits of a zip code. Note that the zip codes and the addresses are randomly ...

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

Custom Number Format in Excel (13 Unique Examples)

Mar 22, 2025

Here's the overview of the Format Cells dialog box, where you can use Custom Formats. Let's showcase some examples for custom formats. ...

Custom Number Format in Excel (13 Unique Examples)

A Complete Guide on How to Pad Zeros in Excel?

May 29, 2024

Method 1 - How to Pad Leading Zero with Custom Format in Excel? Select data range D5:D20 >> Press Ctrl + 1 >> Format Cells dialog ...

A Complete Guide on How to Pad Zeros in Excel?

Excel Date Format

Aug 14, 2024

This is an overview: Click here to enlarge this image. Download Practice Workbook Date Format.xlsx The Date Format in Excel ...

Excel Accounting Number Format (Apply and Customize)

Jul 28, 2024

Here's an overview of where you can find the Accounting format to apply it to cells. Download the Practice Workbook Accounting Number ...

Excel Accounting Number Format (Apply and Customize)

Formatting Currency in Excel (Format, Change & Remove)

Aug 7, 2024

This is the sample dataset. Download Practice Workbook Download the practice workbook. Currency Format in Excel.xlsx How ...

Formatting Currency in Excel (Format, Change & Remove)

Excel Scientific Notation (All Things You Need to Know)

Nov 11, 2025

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)

Write, Display and Convert Fraction in Excel: 7 Methods

May 28, 2024

Method 1 - Using Mixed Fraction Technique to Display Fraction In cell D5, we have written a proper fraction in a mixed fraction manner, where 0 ...

Write, Display and Convert Fraction in Excel: 7 Methods

Decimals in Excel (Add, Remove)

Nov 11, 2025

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)

Aug 4, 2024

Here's an overview of negative numbers in Excel and how they can be formatted. Download the Practice Workbook Negative Number in ...

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

How to Change Number Format in Excel

Nov 11, 2025

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)

Jun 16, 2024

This article will discuss two causes and solutions for why the Number Format might not be working. Number Format Is Not Working in Excel: ...

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

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

Nov 11, 2025

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)

Nov 11, 2025

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)

Jul 29, 2024

We're going to use a dataset of Argentine Football Players’ salaries in club football. We have organized the data in the Name, Team, Salary, and ...