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 |
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 |
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 |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com