Excel Autonumbering help - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 08-15-2005, 09:30 AM   #1 (permalink)
True Techie
 
Join Date: Apr 2005
Posts: 188
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
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: 188
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 Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 03:17 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.