Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
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...
 
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?
| >
| >
| >
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Series fill only copying and fill series greyed out 1
No "Growth Trend" choice on shortcut menu 2
Number series at end of column macro? 4
fill does not work for me what can I do 10
Fill series (weeks) 3
Excell 2000 / create a consecutive list of numbers 4
Can't Explain N/A in Vlookup 2
What is ray tracing ? 1

Back
Top