Decimal Dilemma

A

Arturo

I’m looping through a column of numbers. Each number is stored in a
variable, Y_CellTest, as that row is dealt with and a comparative test is
performed. The value of Y_CellTest can go out a varying number of positions
to the right of the decimal point. How do I alter that variable Y_CellTest,
to read only X numbers of places to the right of the decimal point?
Currently the line reads Y_CellTest = Worksheets(2).Cells(Loop_rO,
coLArray(X_col)). Y_CellTest = 43.3762286964325 but I want it to read only
say 4 places to the right of the decimal point, Y_CellTest = 43.3762.

Appreciatively,
Arturo
 

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

UBound 5
macro to delete all digits to the right of decimal place 3
How to format without decimal point unless significant digits? 3
Help with loop 4
ACCESS TO EXCEL 1
VBA code outputs currency value rounded to 2 decimal points 7
Decimal places in mail merge 1
Number of decimal places output 8

Top