taip ir yra. kvailiausia yra tai, kad VBA palaiko
duomenu formata Double, kurio ribos yra:
Double (double-precision floating-point) variables are stored as IEEE 64-bit 
(8-byte) floating-point numbers ranging in value from -1.79769313486231E308 
to -4.94065645841247E-324 for negative values and from 4.94065645841247E-324 
to 1.79769313486232E308 for positive values.
Be to, VBA turi funkcija FomatNumber, kur gali nurodyti skaiciu ilgi
iki 1024 simboliu, bet daryk, ka nori, vis vien virs 15  neima ir nerodo.
Taip, kad kas skaiciuoja simtais milijardu pinigus, bukit budrus. Galimos
paklaidos virs kablelio :)

veygr

"Gvi2" <gvi2@work.lt> wrote in message 
news:hddtqi$k8f$1@trimpas.omnitel.net...
> Ir neparodys.
> Ištrauka iš Excel Help'o:
>
> Precision   is a measure of the degree of accuracy for a calculation.
> Excel stores and calculates with 15 significant digits of precision.
>
> O tavo rezultate jau 19 reikšminių skaitmenų.
>
>
> "LwJ" <LwJ@Nera.Lt> wrote in message 
> news:hddm0b$895$1@trimpas.omnitel.net...
>> Kalkuliatorius ok, bet va excel'is galo...1375 niekaip nesugeba
>> parodyti...:)
>> "MinVodai" <minvodai@gmail.com> wrote in message
>> news:hdc0jd$lnh$1@trimpas.omnitel.net...
>>> tai gal perdaug protinga turi :)
>>> Nustates koki HEX  :)
>>> o gal OCT, bet tada negaletum ivest 8 ir 9
>>> tai papasakok kokia velniava ten gauni? :)
>>>
>>> "LwJ" <LwJ@Nera.Lt> wrote in message
>>> news:hd93pe$jr7$1@trimpas.omnitel.net...
>>>> Kai paskai?iuoji su kalkuliatorium tada gaunasi velniava
>>>> "gannet" <kas@cia.lt> wrote in message
>>>> news:hd90le$djo$1@trimpas.omnitel.net...
>>>>>o kas negerai?
>>>>> 301,72 ? (tiksliau: 301,7200000000001375)
>>>>>
>>>>> LwJ wrote:
>>>>>> Sveiki,
>>>>>> tokia vat nesamone, sudauginkite excel'yje 21425 ir 
>>>>>> 0,0140826137689615
>>>>>> man kazkokia velniava gaunasi...:(
>>>>
>>>
>>>
>>