Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number format and decimal positions
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number format and decimal positions
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number format and decimal positions
Hi Vasant,
Thank you. I don't think I remember reading in the MSO Excel docum NOT being able to get a decimal answer to an 'integer' division. I also need to apologize, when I extracted the code in a test, I now remember that I did NOT Dim the vars before running my test, so I guess MSO dim'd them as variants, and that's why the test worked, but not the code when it was in the macro. Again Thanks, Neal "Vasant Nanavati" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number format and decimal positions
You're welcome, Neal!
-- Vasant "Neal Zimm" wrote in message ... Hi Vasant, Thank you. I don't think I remember reading in the MSO Excel docum NOT being able to get a decimal answer to an 'integer' division. I also need to apologize, when I extracted the code in a test, I now remember that I did NOT Dim the vars before running my test, so I guess MSO dim'd them as variants, and that's why the test worked, but not the code when it was in the macro. Again Thanks, Neal "Vasant Nanavati" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |