BASE Function Archives

BASE Function

How to Put 0 in Excel in Front of Numbers (5 Handy Methods)

Aug 7, 2022 Excel Basics

While working on an Excel worksheet, you may see that Excel doesn’t allow 0 before any numbers. So, you can’t make a column with the same number of ...

How to Add Leading Zeros in Excel Text Format (10 Ways)

Aug 8, 2022 Excel Basics

In Microsoft Excel, leading zeros can be extremely useful in a variety of applications. A leading zero is any "0" digit in a number string that comes ...

How to Write 001 in Excel (11 Effective Methods)

Aug 7, 2022 Excel Basics

Excel automatically removes the leading zeros from a number when you enter it in a cell. Therefore, you cannot directly write 001 in excel and ...

51 Mostly Used Math and Trig Functions in Excel

Sep 6, 2022 Excel Basics

The Math & Trig functions in Excel are very common in many mathematical calculations like- basic arithmetic, conditional sum & product, ...

44 Mathematical Functions in Excel (Download Free PDF)

Sep 6, 2022 Excel Basics

Microsoft Excel has plenty of mathematical functions that help perform various mathematical operations. In this article, you will get to know 44 ...

Excel Convert Number to Text with Leading Zeros: 10 Effective Ways

Aug 8, 2022 Advanced Excel

Leading zeros aid predominantly to specify the length of a number. In the case of maintaining records such as any special identity number, zip code, ...

How to Add Leading Zeros in Excel (4 Quick Methods)

Aug 8, 2022 Excel Formulas

While working in Excel, we often have to add leading zeros before one or more numbers. This is in fact quite easy to implement. Today I will be ...

Add or Keep Leading Zeros in Excel (10 Suitable Ways)

Aug 8, 2022 Excel Basics 2

In Microsoft Excel, it’s not possible to keep leading zeros by simply typing a number with 0’s at first as Excel, by default, will remove those zeros ...