View Single Post
  #2   Report Post  
Dave R.
 
Posts: n/a
Default

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.