Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2015, 11:16 AM
Stacybug1 Stacybug1 is offline Autofill Mac OS X Autofill Office 2001 for Mac
Novice
Autofill
 
Join Date: Jan 2015
Posts: 2
Stacybug1 is on a distinguished road
Default Autofill

Hello



How can I get Excel to Autofill the numbers as follows across a ROW:

00+00
01+00
02+00
03+00

I'm needing to go from 00+00 to 3506+00

I have spent all morning and I give up!!

I'm using Office 2011 for Mac (not 2001 as my profile indicates.....I selected the wrong one when I signed up)

Thank you in advance.
Reply With Quote
  #2  
Old 01-28-2015, 12:30 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Autofill Windows 7 64bit Autofill Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps
Code:
=TEXT(COLUMN()-1,"####0#")&"+00"
starting in col A.Drag right as needed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 01-28-2015, 01:04 PM
Stacybug1 Stacybug1 is offline Autofill Mac OS X Autofill Office for Mac 2011
Novice
Autofill
 
Join Date: Jan 2015
Posts: 2
Stacybug1 is on a distinguished road
Default

Thank you SOOOO much!!!!!!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Autofill Looking for a way to autofill a number in a label. 10nry Word VBA 4 10-27-2014 04:46 PM
Autofill Address dazwm Outlook 13 08-21-2013 09:28 AM
Autofill Autofill Automation Parkiee1981 Excel 4 03-15-2013 01:24 PM
AutoCorrect Or AutoFill Johnny thunder Outlook 0 05-02-2011 03:37 PM
Autofill Need cells to autofill with color Silver Rain 007 Excel 1 10-22-2009 08:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft