Stuart McLachlan
stuart at lexacorp.com.pg
Thu Sep 7 16:45:28 CDT 2006
On 7 Sep 2006 at 16:57, JWColby wrote: > Probably a single. No! Maximum precision 7 places. That would store and manipulate it as 34567900000000 >> What would you dim the following number as in VBA >> >> 34567899999999 >> >> In order to carry out math on it. You will have to use either a Double or Currency. Which one depends on what sort of math you want to do. Double will allow you to use larger numbers but currency will give you greater precision. -- Stuart