Divide 2 number and get a desimal in VBA

M

MrDeej

HEllo!

I have a VB code which calulates a number for me

ex:
1 / 30 = 3,333334E-02

it is going to store the result, which should be 0,33, in a table.

How do i make VBA calculate correct and how do i format the field in the
table to match this?
 
P

Pendragon

use the Round function (or one of the variants, depending on what you want).
Check out Help for definitions and examples.
 
K

karl dewey

3.333334E-02 is correct. It is scientific notation of the number.
3.333334E-02 equals 0.03333333333

Try using your calculator to divide 1 by 30 and it will not indicate 0.33
but 0.033333333333333 or how ever many places it will display.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Excel does not accept text format! 0
Paragraph numbering in Word 1
Finding the proper style field and the numbered paragraph value within the style 0
Data Entry VBA 4
VBA code returns no records hwenKey ID is added 14
Data entry for a table from a form 1
Difference between 2 calculated fields showed as % of grand total 0

Top