DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

What is CSng Function in VBA Excel office 365? – Quick Tricks!!

#whatiscsngfunction #vbamacros

Have you ever tried to learn about CSng Function In your Excel Spreadsheet? In this tutorial, we will guide you about what is CSng Function in VBA Excel Office 365. Let’s get them below!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

CSng Function

  • The CSng function is a VBA function that converts any data type to a single-precision floating-point number (“given that it is a number”).
  • It is used in the CSng function to convert text formatted numbers into actual numbers.

CSng Function Syntax 

CSng(expression)
Enter fullscreen mode Exit fullscreen mode

Syntax Explanation:

expression: It can be any expression. A text or a method that returns some values.

Example-Convert Text to Number using VBA

  • Firstly, in the Excel Worksheet, you have to go to the Developer Tab.
  • Then, you need to ** ** select the Visual Basic option under the Code section.

Select Visual basics

  • Now, you have to copy and paste the code given below. 
Sub TextToNumber()
 stri="5.5"
 stri = CSng(stri)
 debug.print stri
End Sub
Enter fullscreen mode Exit fullscreen mode
  • After that, you need to save the code by selecting it and then close the window.

  • Again, you have to go to the Excel Spreadsheet , and click on the Developer Tab.
  • You need to choose the Macros option in the Code section.

Choose Macro option

  • Now, you have to make sure that your macro name is selected and click the *Run * button.

Run the Code

  • Finally, the CDec function converts given expression into a decimal number , and it displays output in a Worksheet.

End of Era

We hope that this tutorial gives you guidelines on what is CSng Function in VBA Excel Office 365. ** Please leave a comment in case of any **queries, and don’t forget to mention your valuable suggestions as well. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *Read more on Excel Formulas *!!

Read Next:

Top comments (0)