Computer Forums

Member Login

Remember Me? Sign Up! | Forgot Password
 
Slogan
 
Closed Thread
Old 08-15-2005, 09:30 AM   #1 (permalink)
 
True Techie

Join Date: Apr 2005

Posts: 193

Seiken

Default Excel Autonumbering help

I have to create a spreadsheet with the first column (A) containing a set of numbers - in this case 140478 down to 140800.

What is the formula? Thanks.
Seiken is offline  
Old 08-15-2005, 09:54 AM   #2 (permalink)
 
Super Techie

Join Date: Dec 2004

Posts: 487

benzimm86 is on a distinguished road

Send a message via AIM to benzimm86
Default

The first step is to type 140478 in sell a1. then click on cell a2. Now at the top where you see the fx type a1+1. then hit enter and the number 140479 will appear.put the cursor at the bottom right corner of cell a2 until you see a little plus sign. click and drag down until you reach thenumber you want
__________________
amd athlon xp2100+
asus a7v333 mb
nvidia geforce4mx 420 64 mb
thermaltake volcano 12
1 gig ddr pc2100
thermaltake purepower 420w psu
dvd-rw
audigy 2 platinum sound card
benzimm86 is offline  
Old 08-15-2005, 10:09 AM   #3 (permalink)
 
True Techie

Join Date: Apr 2005

Posts: 193

Seiken

Default

thanks.
Seiken is offline  
 
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On