Excel 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

billytre - 17 May 2006 10:31 GMT

I have a filled series of numbers that are relative. How do I change them to
absolute?

Reply to this Message

Bob Phillips - 17 May 2006 10:35 GMT

Do you that they are produced via formulae?

Signature

HTH

Bob Phillips

(remove xxx from email address if mailing direct)

> I have a filled series of numbers that are relative. How do I change them to
> absolute?

Reply to this Message

billytre - 17 May 2006 10:45 GMT

No Bob, Just a straight fill by dragging.

> Do you that they are produced via formulae?
>
> > I have a filled series of numbers that are relative. How do I change them
> to
> > absolute?

Reply to this Message

Niek Otten - 17 May 2006 11:03 GMT

Now what does "relative" mean then?
Can you give examples of your numbers?

Signature

Kind regards,

Niek Otten

| No Bob, Just a straight fill by dragging.
|
[quoted text clipped - 3 lines]
| > to
| > > absolute?

Reply to this Message

billytre - 17 May 2006 23:04 GMT

Thanks Niek

9000, 9001, 9002 and on.

9000 is absolute ( a real number), while subsequent numbers are connected by
the auto fill (relative I guess) to the first number 9000. When I sort the
spreadsheet these numbers get moved around in unpredictable ways.

regards Billytre

> Now what does "relative" mean then?
> Can you give examples of your numbers?
[quoted text clipped - 6 lines]
> | > to
> | > > absolute?

Reply to this Message