Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding decimals in a summ
HI
working on excel 2003 this what I had set up in a macro (cell A1 as a value of 12,32) my macro: Dim timpt as long timpt = timpt + cells(1,1).value the result is 12,00 What I would like and I cannot get it is to keep the decimals and not to have as a result a rounded number Any help will be appreciated Thanks Francesco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format monetary amount to 9 digits with No decimals without rounding | Excel Worksheet Functions | |||
Rounding Decimals | Excel Discussion (Misc queries) | |||
Rounding results to nearest quarter (in decimals) | Excel Discussion (Misc queries) | |||
rounding numbers, with-out decimals. IE:4507 to 4510 | Excel Worksheet Functions | |||
Rounding Decimals | Excel Worksheet Functions |