Problems with dragging series of decimal numbers.


G

Guest

Several people I work with are getting this problem, so maybe it's a bug and
I'll have to hope that the Excel Gods one day fix this.

Example: We type in .111 in A1 and then .112 in A2. Then select both and
drag them down about 800 rows. At some point, the numbers will change from
..xxx to .xxxxxxxxxxxxxxxx. Once the series of numbers reach 1.000, the
problem will go away. Has anyone seen this issue and if so, come up with a
resolution? This is screwing up different tables and graphs that our users
are setting up.

We are running Office 2003 SP1 on Windows XP SP1.

Any help or suggestions would be appreciated.

Thanks,
 
Ad

Advertisements

G

Guest

hi,
it a bug i have been wanting fixed for about 14 years now.
If seems to effect all products using VBA. don't know what
causes. I first noticed it when we switch from lotus to
excel. lotus never did that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top