A Long is an integer, so you will get only integral values for your
variables.

numba and numbb should be DIMmed as Single.

--

Vasant


"Neal Zimm" wrote in message
...
I am stumped.

this code is part of much larger macro.

Range(Cells(drprw, 6), Cells(drprw + 1, 6)).NumberFormat = "0.00"
numba = Round(qtytpd / qtyroutes, 2)
numbb = Round(tpaftot / qtyroutes, 2)
Cells(drprw, 6) = numba
Cells(drprw + 1, 6) = numbb

the cells are displaying numbers like 9.00 when there should be
non zero decimal positions.

if i pull the code out of the macro, and run it standalone,
it works fine.

all vars are dim'd as long.

i' ve checked the code 'after' this, and there are NO other formating
commands.
I don't know where to 'look' next.

Help. Thanks. Neal.



--
Neal Z