Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > Numbering off in Excel

Numbering off in Excel
Thread Tools
Richard Clark
Senior User
Join Date: Apr 2000
Status: Offline
Reply With Quote
May 22, 2002, 12:30 PM
 
We have a gal using Excel (2001) who needs to number off every 16 cells. Is there a way to automatically do that?


Also have one more question - The data in one column is of currency that is rounding off to two decimal places. The information is being imported into Filemaker Pro 5.5. It keeps the entire amount and doesn't round off Is there a way for it export out of Excel still rounded?

Thanks in advance for any tips, tricks or help!
"Tough Little Ship" - Riker
"LITTLE?" - Worf after having the Defiant salvaged by the Enterprise (First Contact)
     
ringo
Professional Poster
Join Date: Oct 2001
Location: PA
Status: Offline
Reply With Quote
May 22, 2002, 06:33 PM
 
Yeah, type 1 in A1, 2 in A2, then select cells A1 and A2.
With A1 and A2 selected, grab the bottom right corner of A2 (the pointer will change), and drag down to A16. Excel will auto fill 3 - 16.

After the above, you could just copy A1 - A16 and paste in A17, A33, etc to repeat the 1-16 count.
     
   
 
Forum Links
Forum 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
Top
Privacy Policy
All times are GMT -4. The time now is 09:12 PM.
All contents of these forums © 1995-2017 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2017, Jelsoft Enterprises Ltd.,