Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting decimal number to hh:mm format | Excel Discussion (Misc queries) | |||
Format for Whole number and 1 Decimal in same Cell | Excel Worksheet Functions | |||
Custom format whole number to decimal | Excel Worksheet Functions | |||
Number format still uses decimal point | New Users to Excel | |||
I want to format a number cell without the decimal and without ro. | Excel Discussion (Misc queries) |