Excel 2000

B

billytre

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

Bob Phillips

Do you that they are produced via formulae?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
B

billytre

No Bob, Just a straight fill by dragging.

Bob Phillips said:
Do you that they are produced via formulae?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
Click to expand...
 
N

Niek Otten

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

--
Kind regards,

Niek Otten

| No Bob, Just a straight fill by dragging.
|
| "Bob Phillips" wrote:
|
| > Do you that they are produced via formulae?
| >
| > --
| > 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?
| >
| >
| >
 
B

billytre

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
 
Top