EXCEL VBA Caluculation ERROR

[beersa]

I type
?1/3 in excel vba immidiate window
I got the answer 1.323434 instead 1.3333

Can help me why it occurs?

Thks

beersa

 

[Gordon Beaton]

I type
?1/3 in excel vba immidiate window
I got the answer 1.323434 instead 1.3333

Can help me why it occurs?

It's truly a mystery, since 1/3 is 0.333333....

/gordon

 

[Rhino]

I type
?1/3 in excel vba immidiate window
I got the answer 1.323434 instead 1.3333

Can help me why it occurs?

A better place to ask would be a newsgroup that deals with Excel. This is a
programming group for the Java language.

Try microsoft.public.excel.misc. I'm not sure if it is the best of the Excel
newsgroups for this question but they should be able to point you to the
correct newsgroup.

 

[TechBookReport]

I type
?1/3 in excel vba immidiate window
I got the answer 1.323434 instead 1.3333

Can help me why it occurs?

Thks

beersa

1. This is a Java newsgroup, not Excel or VBA

2. Doesn't happen here, comes out as 0.3333333