FORMAT Function Archives

FORMAT Function

VBA Format Function in Excel (8 Uses with Examples)

Feb 9, 2023

The Format function in Excel is a built-in function categorized as a String/ Text function. It is also used as a VBA function in Excel. In this ...

VBA Format Function in Excel (8 Uses with Examples)

VBA Date to String Conversion in Excel (6 Methods)

Jun 20, 2023

Generally, Microsoft Excel performs any task much faster than we do it manually. In this article, we will see how to convert VBA date to string in ...

VBA Date to String Conversion in Excel (6 Methods)

How to Use TRUNC Function in Excel (4 Examples)

Feb 27, 2023

The TRUNC function in Excel truncates a number to a specified number of digits. It is under the category of Excel Math and Trigonometry function. The ...

How to Use TRUNC Function in Excel (4 Examples)

How to Get the Current Date in VBA (3 Ways)

Jun 20, 2023

In this article, I’ll show you how you can get the current date in VBA in Excel. You’ll learn to show the current date, show the current time, as ...

How to Get the Current Date in VBA (3 Ways)

How to Convert Date from String Using VBA (7 Ways)

Feb 27, 2023

If you are looking for some of the easiest ways to convert date from string using VBA, then you are in the right place. By using a VBA code you can ...