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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding decimals in a summ
Dim timpt as Double
timpt = timpt + cells(1,1).value -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Francesco" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding decimals in a summ
Thaks a lot Bob Finally I got the decimals displayed and not rounded
have a nice day thanks again Francesco "Bob Phillips" wrote: Dim timpt as Double timpt = timpt + cells(1,1).value -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Francesco" wrote in message ... 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 |
Reply |
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 |