EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home VBA VBA Resources VBA Conversion Functions VBA CDEC
Secondary Sidebar
VBA Conversion Functions
  • VBA Conversion Functions
    • VBA CDEC
    • VBA CLng
    • VBA Value
    • VBA CHR
    • VBA CDBL
    • VBA Val
    • VBA CSTR
    • VBA CDate
    • VBA Double
    • VBA CInt

VBA CDEC

By Ashwani JaiswalAshwani Jaiswal

VBA CDEC

CDEC Function in VBA

CDEC function in VBA is an inbuilt function of conversion, which usually known as “Convert to Decimal’. Now as we know, its full name which clearly states its work which is used to convert a number into decimal. It does not directly convert an integer number into a decimal, but it allows us to keep the decimal digits up to any number of digits. If you see the syntax of VBA CDEC, it just requires the expression to be selected as shown below.

VBA CDEC Syntax

Where, Expression = Decimal number which we need to convert or retain in decimal format.

For this, we have other data types as well such as Double, Long or Integers which are used for numbers. But there are some constraints using all the mentioned data type.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Integer data type only considers whole numbers and that is also between -32,768 to 32,767, Long data type allows 4 Byte of data into which is between -2,147,483,648 to 2,147,483,648.

All in One Financial Analyst Bundle(250+ Courses, 40+ Projects)
Financial ModelingInvestment BankingUS GAAPCFA-Level 1 & 2
Equity ResearchM & A ModelingPrivate Equity ModelingForex Trading
Price
View Courses
250+ Online Courses | 40+ Projects | 1000+ Hours | Verifiable Certificates | Lifetime Access
4.9 (86,641 ratings)

And Double data type allow 8 Byte of data which is from -1.79769313486232e+308 to 1.79769313486232e+308. Whereas in CDEC function, we can store any type of decimal number and perform any type of mathematical operations in which decimals are involved but it Variant and Double data types.

How to Use the CDEC Function in Excel VBA?

We will learn how to use a CBEC Function in Excel by using the VBA Code. For this, follow the below steps:

You can download this VBA CDEC Excel Template here – VBA CDEC Excel Template

Example #1

First, we will see a simple VBA Code where we will try to print a decimal value using the Integer data type.

Step 1:  Insert a new module inside Visual Basic Editor (VBE). Click on Insert tab > select Module.

Insert Module

Step 2: Write the subprocedure preferably in the name of performed operations.

Code:

Sub VBA_CDEC()

End Sub

VBA CDEC Example 1-2

Step 3: Define a variable using DIM as Integer. 

Code:

Sub VBA_CDEC()

Dim A As Integer

End Sub

VBA CDEC Example 1-3

Step 4: Now assign any decimal number of any length in the defined variable. 

Code:

Sub VBA_CDEC()

Dim A As Integer
A = 1.234567

End Sub

VBA CDEC Example 1-4

Step 5: And to print the value stored in variable A we can use MsgBox or Debug Print. Here we are using Msgbox.

Code:

Sub VBA_CDEC()

Dim A As Integer
A = 1.234567
MsgBox A

End Sub

Integer Example 1-5

Step 6: Now compile the code by pressing function key F8 and to run the code, click on the Play button located below the menu bar. We will get a message box with the number as integer (Whole number) as shown below.

VBA CDEC Example 1-6

Step 7: Now as we understood the Integer data type will not convert or retain any decimal numbers. Now let try to change the data from Integer to Variant.

Code:

Sub VBA_CDEC()

Dim A As Variant
A = 1.234567
MsgBox A

End Sub

Variant Example 1-7

Step 8: Now if we run the code, we would probably get the mentioned decimal values as 1.234567.

VBA CDEC Example 1-8

Step 9: Now if we cover the earlier used decimal value in CDEC function. And see what we get.

Code:

Sub VBA_CDEC()

Dim A As Variant
A = 1.234567
MsgBox A

End Sub

VBA CDEC Example 1-9

Step 10: Now again, we run the code by pressing function key F5, and to run the code, click on the Play button. we would get the same decimal value as CDEC is meant for decimal values only.

VBA CDEC Example 1-10

Step 11: Now let test the limit of CDEC function by keeping the 10 digit decimal numbers as 1.2345672347.

Code:

Sub VBA_CDEC()

Dim A As Variant
A = CDec(1.2345672347)
MsgBox A

End Sub

VBA CDEC Example 1-11

Step 12: Now run this code by pressing function key F8. We will see the message with a complete 10 decimal digit number.

VBA CDEC Example 1-12

Step 13: As we know the Double data type can only uphold the decimal number up to 14 digits. Let’s test CDEC function with a number of decimal values up to 18 digits which is 1.234567234723456723.

Code:

Sub VBA_CDEC()

Dim A As Variant
A = CDec(1.234567234723456723)
MsgBox A

End Sub

VBA CDEC Example 1-13

Step 14: We will see in the message box that CDEC only returned the decimal value up to 14 digits which is same as DOUBLE data type.

DOUBLE Data Type Example 1-14

Step 15: To keep the limit of decimal values which we entered up to 18 digits, let try to cover the value in inverted commas and increasing the decimal digits up to 25.

Code:

Sub VBA_CDEC()

Dim A As Variant
A = CDec("1.23456723478923234567234789")
MsgBox A

End Sub

VBA CDEC Example 1-15

Step 16: And if we see the output in the message box, then we will notice that it has the same value which we fed in above VBA Code.

VBA CDEC Example 1-16

Example #2

In this example, we will perform a simple mathematical operation like multiplication using the same type of VBA Code.

Step 1:  For this again open a new module and using DIM define a variable considering DOUBLE data type.

Code:

Sub VBA_CDEC2()

Dim A As Double

End Sub

DOUBLE Data Type Example 2-1

Step 2: Now let try to multiply some decimal numbers as shown below. There is no restriction to use any type of value in it.

Code:

Sub VBA_CDEC2()

Dim A As Double
A = CDec(1.0232 * 1.00044 * 0.3333338979)

End Sub

Decimal Numbers Example 2-2

Step 3: And to see the output, we will use msgbox.

Code:

Sub VBA_CDEC2()

Dim A As Double
A = CDec(1.0232 * 1.00044 * 0.3333338979)
MsgBox A

End Sub

Msgbox Example 2-3

Step 4: And if we run the code by pressing function key F5 and to run the code, click on the Play button located below the menu bar, we will get the output.

VBA CDEC Example 2-4

We can try to test this code, using the different types of data types. But using CDEC with Variant data type gives the decimal value up to 28 digits.

Pros of VBA CDEC:

  • CDEC is also another type of simplest function to be used for decimal values.
  • It allows us to see the decimal values up to any length if used in inverted commas.

Things to Remember

  • CDEC stands for “Convert to Decimal” which only accepts Variant data types if we want to see the decimal numbers up to 28 digits.
  • CDEC rounds off the number of not used in inverted commas up to 14 digits.
  • Generally, CDEC is not used but it could be used mainly into statistics where huge precision needs to be taken for any kind of calculation.
  • We can convert a number to into decimal using CDEC function easily whereas we all know there is no other data type available to get such lengthy decimal values.

Recommended Articles

This is a guide to the VBA CDEC. Here we discuss how to convert an integer number into a decimal using CDEC function in excel VBA along with practical examples and downloadable excel template. You can also go through our other suggested articles –

  1. How to Use VBA Login?
  2. VBA Month | Examples With Excel Template
  3. How to Use Create Object Function in VBA Excel?
  4. How to Use VBA IsError Function?
Popular Course in this category
All in One Excel VBA Bundle (120+ Courses)
  120+ Online Courses |  500+ Hours |  Verifiable Certificates |  Lifetime Access
4.9
Price

View Course
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign In
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more