Yes, I noted that... it is why I included the words "I think" in my reply.

--
Rick (MVP - Excel)


"Ron Rosenfeld" wrote in message
...
On Sun, 22 Mar 2009 00:40:37 -0400, "Rick Rothstein"
wrote:

Since the OP wants a value that appears in the column, I think you will
need
another INT function call...

=INT(100000000/INT(100000000/D1))


You MAY be correct BUT since the OP wrote:

" **Note: you'll notice that this list of numbers has a pattern. It is
1/N*100000000 "

I thought it likely that the display of integers is related to formatting
rather than rounding.
--ron