I am trying to resolve an issue that several of our users have been
experiencing.

I've been able to duplicate it on all of our systems. Example: Type .101
in Cell A1 and then type .102 in Cell A2. Select both cells and then drag to
fill all the cells in a series to cell 1000. At some point(most cases line
564, the format changes from .xxx to .xxxxxxxxxxxxxxxx). This has resolved
in many issues when doing tables and charts.

Running XP SP1 and Office 2003 SP1.

Any suggestions.

Thanks.

For me, it starts with 0.143999999999999.. but it doesn't change the format
of the number here with XL 2003.

If it bothers them that much, they can use

=ROUND(A1+0.001,3) and fill that down instead.



"EXCELNCBOY" wrote in message
...
I am trying to resolve an issue that several of our users have been
experiencing.

I've been able to duplicate it on all of our systems. Example: Type .101
in Cell A1 and then type .102 in Cell A2. Select both cells and then drag
to
fill all the cells in a series to cell 1000. At some point(most cases
line
564, the format changes from .xxx to .xxxxxxxxxxxxxxxx). This has
resolved
in many issues when doing tables and charts.

Running XP SP1 and Office 2003 SP1.

Any suggestions.

Thanks.

You have been given great answer for fixing the problem but if you are
interested in the WHY then you need to learn how computers store numbers in
binary notation (aka IEEE convention) and that some decimal numbers (the
type we use because of 10 fingers) cannot be accurately represented when
using 15 digit binary precision. A bit like not being able to exactly write
1/3 as a fraction.

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"EXCELNCBOY" wrote in message
...
I am trying to resolve an issue that several of our users have been
experiencing.

I've been able to duplicate it on all of our systems. Example: Type .101
in Cell A1 and then type .102 in Cell A2. Select both cells and then drag
to
fill all the cells in a series to cell 1000. At some point(most cases
line
564, the format changes from .xxx to .xxxxxxxxxxxxxxxx). This has
resolved
in many issues when doing tables and charts.

Running XP SP1 and Office 2003 SP1.

Any suggestions.

Thanks.

Microsoft acknowledges there is an "issue" with the drag feature. In Excel
2003, this problems starts for me at 0.144, the same as Dave. If you just
add 0.001 to the cell above and drag down, you can usually go a little
further till computer rounding issues kick in. For me, it was able to go to
0.688 before computer rounding problems started. Microsoft recommends using
the Round function as Dave has shown, or using Edit | Fill | Series. I
assume that Edit | Fill | Series uses some sort of built-in rounding, and
this is why Microsoft recommends this over selecting two cells, and dragging
down. A usual quick and dirty technique is to drag down like you have done
to get the value of the bottom cell. Then, redo this with Edit | Fill |
Series and insert a stop value.

--
Dana DeLouis
Win XP & Office 2003


"EXCELNCBOY" wrote in message
...
I am trying to resolve an issue that several of our users have been
experiencing.

I've been able to duplicate it on all of our systems. Example: Type .101
in Cell A1 and then type .102 in Cell A2. Select both cells and then drag
to
fill all the cells in a series to cell 1000. At some point(most cases
line
564, the format changes from .xxx to .xxxxxxxxxxxxxxxx). This has
resolved
in many issues when doing tables and charts.

Running XP SP1 and Office 2003 SP1.

Any suggestions.

Thanks.

Since there is no problem in XL2k and XL97, then I assume it's not a "binary
math" problem ... correct ?

OR, are there built in roundings in those "drag" versions?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"Dana DeLouis" wrote in message
...
Microsoft acknowledges there is an "issue" with the drag feature. In Excel
2003, this problems starts for me at 0.144, the same as Dave. If you just
add 0.001 to the cell above and drag down, you can usually go a little
further till computer rounding issues kick in. For me, it was able to go to
0.688 before computer rounding problems started. Microsoft recommends using
the Round function as Dave has shown, or using Edit | Fill | Series. I
assume that Edit | Fill | Series uses some sort of built-in rounding, and
this is why Microsoft recommends this over selecting two cells, and dragging
down. A usual quick and dirty technique is to drag down like you have done
to get the value of the bottom cell. Then, redo this with Edit | Fill |
Series and insert a stop value.

--
Dana DeLouis
Win XP & Office 2003


"EXCELNCBOY" wrote in message
...
I am trying to resolve an issue that several of our users have been
experiencing.

I've been able to duplicate it on all of our systems. Example: Type .101
in Cell A1 and then type .102 in Cell A2. Select both cells and then drag
to
fill all the cells in a series to cell 1000. At some point(most cases
line
564, the format changes from .xxx to .xxxxxxxxxxxxxxxx). This has
resolved
in many issues when doing tables and charts.

Running XP SP1 and Office 2003 SP1.

Any suggestions.

Thanks.

I did not know this 'feature' is new.
Maybe it is a binary arithmetic problem; perhaps the programmers changed the
algorithm for this procedure.

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"RagDyer" wrote in message
...
Since there is no problem in XL2k and XL97, then I assume it's not a
"binary
math" problem ... correct ?

OR, are there built in roundings in those "drag" versions?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"Dana DeLouis" wrote in message
...
Microsoft acknowledges there is an "issue" with the drag feature. In
Excel
2003, this problems starts for me at 0.144, the same as Dave. If you
just
add 0.001 to the cell above and drag down, you can usually go a little
further till computer rounding issues kick in. For me, it was able to go
to
0.688 before computer rounding problems started. Microsoft recommends
using
the Round function as Dave has shown, or using Edit | Fill | Series. I
assume that Edit | Fill | Series uses some sort of built-in rounding, and
this is why Microsoft recommends this over selecting two cells, and
dragging
down. A usual quick and dirty technique is to drag down like you have
done
to get the value of the bottom cell. Then, redo this with Edit | Fill |
Series and insert a stop value.

--
Dana DeLouis
Win XP & Office 2003


"EXCELNCBOY" wrote in message
...
I am trying to resolve an issue that several of our users have been
experiencing.

I've been able to duplicate it on all of our systems. Example: Type
.101
in Cell A1 and then type .102 in Cell A2. Select both cells and then
drag
to
fill all the cells in a series to cell 1000. At some point(most cases
line
564, the format changes from .xxx to .xxxxxxxxxxxxxxxx). This has
resolved
in many issues when doing tables and charts.

Running XP SP1 and Office 2003 SP1.

Any suggestions.

Thanks.

Thank you all for your input. I'll review the Edit-Fill Series with the
users which should make them happy.

"Bernard Liengme" wrote:

I did not know this 'feature' is new.
Maybe it is a binary arithmetic problem; perhaps the programmers changed the
algorithm for this procedure.

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"RagDyer" wrote in message
...
Since there is no problem in XL2k and XL97, then I assume it's not a
"binary
math" problem ... correct ?

OR, are there built in roundings in those "drag" versions?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"Dana DeLouis" wrote in message
...
Microsoft acknowledges there is an "issue" with the drag feature. In
Excel
2003, this problems starts for me at 0.144, the same as Dave. If you
just
add 0.001 to the cell above and drag down, you can usually go a little
further till computer rounding issues kick in. For me, it was able to go
to
0.688 before computer rounding problems started. Microsoft recommends
using
the Round function as Dave has shown, or using Edit | Fill | Series. I
assume that Edit | Fill | Series uses some sort of built-in rounding, and
this is why Microsoft recommends this over selecting two cells, and
dragging
down. A usual quick and dirty technique is to drag down like you have
done
to get the value of the bottom cell. Then, redo this with Edit | Fill |
Series and insert a stop value.

--
Dana DeLouis
Win XP & Office 2003


"EXCELNCBOY" wrote in message
...
I am trying to resolve an issue that several of our users have been
experiencing.

I've been able to duplicate it on all of our systems. Example: Type
.101
in Cell A1 and then type .102 in Cell A2. Select both cells and then
drag
to
fill all the cells in a series to cell 1000. At some point(most cases
line
564, the format changes from .xxx to .xxxxxxxxxxxxxxxx). This has
resolved
in many issues when doing tables and charts.

Running XP SP1 and Office 2003 SP1.

Any suggestions.

Thanks.