Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormatNumber
ActiveCell.Value = IntT(ActiveCell.Value * 100) / 100
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Nate Lasko" wrote in message ... this piece of code ActiveCell.Value = FormatNumber(ActiveCell.Value, 2) I dont want it to round the number i am performing the function. any way I can get around that??? I just want it to truncate any numbers after the second decimal place Please help!!! Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatnumber | Excel Programming |