list of sequential numbers

I would like to make a colum of sequential numbers say beginning with 401 and 
ending with 499. is there a way to do this without typing in each individual 
number?
0
kellyaek (2)
12/3/2004 3:49:02 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
343 Views

Similar Articles

[PageSpeed] 25

Hi

see the answer under your originial question titled "numbers in columns"

Cheers
JulieD

"kellyaek" <kellyaek@discussions.microsoft.com> wrote in message 
news:67FF6C4E-4AFC-4E23-8EC0-987A682318F4@microsoft.com...
>I would like to make a colum of sequential numbers say beginning with 401 
>and
> ending with 499. is there a way to do this without typing in each 
> individual
> number? 


0
JulieD1 (2295)
12/3/2004 3:50:16 PM
Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

"kellyaek" <kellyaek@discussions.microsoft.com> schrieb im Newsbeitrag
news:67FF6C4E-4AFC-4E23-8EC0-987A682318F4@microsoft.com...
> I would like to make a colum of sequential numbers say beginning with
401 and
> ending with 499. is there a way to do this without typing in each
individual
> number?

0
frank.kabel (11126)
12/3/2004 4:45:24 PM
Reply:

Similar Artilces:

Using TEXT and &TEXT
I'm familiar with the TEXT function, but sometimes a number will display incorrectly when I format numbers to display with a comma if 4 digits or more. For example, TEXT(F1,"0,0") will display 10 thru 999 correctly and displays 1000 correctly as 1,000, but displays 1 thru 9 as 01, 02, etc. Also wondering how to format part of a TEXT formula to underline, and bold or color selected words. Maybe you want: =text(f1,"#,###") or =text(f1,"#,##0") If this doesn't help, maybe you could post the values and what you want to see for a few exa...

Customizing Activities\History LIst
Is there a way to add a date to Activities' History list? It would be nice to know when each activity happened. Thanks, Troy Troy, no way currently, although Microsoft has mentioned it might be an option in version 2.0 (nothing is guaranteed!) A few ISVs have custom products that do it... www.salentica.com www.c360.com Dave "Troy" <anonymous@discussions.microsoft.com> wrote in message news:af6b01c436bd$ce671f00$a001280a@phx.gbl... > Is there a way to add a date to Activities' History > list? It would be nice to know when each activity > happened. >...

Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will be numbered in "level 1" and have indented bullets in "level 2." For such a list is it better to define a multi-level list style and linked paragraph styles? Or use one's already defined numbered list and use one of the Word's pre-defined bullet lists when needed for the second level? As part of this question, is is preferable not to have a style "nested" within another style or doesn't it matter? Thank you. -- Norm Hi Norm: I'm not sure why yo...

Distribution List Changes
Hi All, I have a mail enabled distribution list with four users. Only those users plus the Administrator have rights on this group. Yet a seperate user is able to add / edit or remove users to this group even though they do not belong to this group. The user does not even have admin rights and is able to make changes. Let me know of any options I can try. Thanks Waynear wrote: > Hi All, > > I have a mail enabled distribution list with four users. Only those > users plus the Administrator have rights on this group. > > Yet a seperate user is able to add / edit or remov...

Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some do not. All sound came from the same folder. Also, when playing the slides while in PPPresentation, swome have sound and some do not despite all being indicated on custom annimation lisy and all startin "after previous." Thanks! Often when one sound plays but another doesn't, it's an issue of the length of the file path. What's the file path to your music? Is it really long? If so, the longer-named songs might just be hitting the length limit. -- Echo [MS PPT MVP] http://www.ec...

Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I have a drop down list like this [image: http://www.geocities.com/augurtrade/excel_checkbox.txt] and this [image: http://www.geocities.com/augurtrade/excel_checkbox2.txt] ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible for me to see only all the check box that was checked or vice versa...??? How to make a total below the checkbox i mean when someone check the check box, a total number appear below the last check box [image: http://www.geocities.com/augurtrade/excel_checkbox3.txt] [image: http://www.g...

how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted me is still on this list (I don't think she blocked me), but when I check who deleted me on blockstatus.com, he shows up. could it be it's not updated? which of the two would be more reliable? -- maykk Greetings, Do not use these websites, they will steal your identity and sell it. You should change your password immediately. That said, in general, the "who has..." list within Messenger is accurate. There have been instances over the last six-months or so where the list (and m...

Continue Numbering #2
I'm wondering if the "Continue numbering" option is in Publisher as it is in Word? Example: I start creating a numbered list. After the second item, I need to insert a few bullets. I then want to go back to the numbered list. Word has a smart tag, asking if you want to continue numbering. Is there a similar feature in Publisher? Right now, I have to go to Format, Bullets & Numbering and change the start number every time this happens. ...

Split text and number
Cell A1 = New England 30, Oakland 20. Is it possible to have the following: cell B1 = New England cell C1 = 30 cell D1 = Oakland cell E1 = 20 Cells A2-A16 are similar but the team name and number changes and the team names are all different lengths. If that won't work I could use text to columns and split it at the , so cell A1 = New England 30 and cell B1 = Oakland 20. But I would still want the team name and score to be separated. Using the above method would save me from having to use the text to columns command. Thanks If you use the text to column, you could then use =r...

Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those with a common extension i.e. all those who have email addresses @hotmail. I am using Outlook 2007 Can you do a search or advanced search which will show the contact you want to delete? You should be able to highlight & delete them from the results. "GrahamC" <GrahamC@discussions.microsoft.com> wrote in message news:6AC1880D-9632-4ED9-BAE2-7083690B9FA7@microsoft.com... > I have all my contacts in the Contacts List and I want to delete all those > with a common extension i.e. all t...

Script to list access right
Hi I am trying to find any script which would generate list of login users with certain access level (select, write etc.) at one particular database. Is there something like that? Thanks. Justin ...

Smart List export to Excel #2
Hi, We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List export to Excel, we keep getting an "Exception_Class_Object_Exception" that references varying object errors, such as 'Cells' or 'Value'; the object errors will change each time we try an export. As a workaround, I've found that closing Excel before doing the export allows the export to complete successfully. However, that solution isn't acceptable, as our Dynamics users would like to be able to work in Excel, doing other tasks, while the export is processing. Does anyone...

a list of lists
currently i use CArray to keep track of a list of objects, but I don't know MFC classes well enough to keep track of a list of lists. I'd appreciate some suggestions "wanwan" <ericwan78@yahoo.com> ha scritto nel messaggio news:1187535523.924671.143350@j4g2000prf.googlegroups.com... > currently i use CArray to keep track of a list of objects, but I don't > know MFC classes well enough to keep track of a list of lists. I'd > appreciate some suggestions You might want to embedd your list based on CArray into a class (e.g. CListOfSomething), and then ...

week numbers
Hi, In MS CRM you have week numbers which aren't equal to the ones we use in the Netherlands. CRM says that 1 januari is week 1, but that isn't correct for us. For us is the first week of the year where we have 4 days in januari. How could I change this? Microsoft Outlook does it correct. thanks in advance, Hi, We had the same problem and found the following solution! Make a backup of the [CRM-Directory]\_controls\datetime\date.js in and then open it and replace the getWeekNumber function with the following code: function getWeekNumber( oDate ) { var oSiebterJanuar = new...

Truncating and rounding off numbers in VBA
Two simple questions that hopefully have simple solutions to them. 1) I want to truncate a number (34.6) so the end result only shows 34. I cannot find the function in VBA and its help service is of no help? IS there one and if so what is it? 2) Also, is there a function for rounding off as well. I tried to set the decmals property for an unbound textbox control to 1 but it has no effect on the result numbers that come out (eg. 24.3245 instead of 24.3). Why is that and how can I solve this? I was thinking I could use a roundoff function in VBA but can't find what it is or if it e...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway to have exchange add the GAL to the outlook contacts on the workstation, so that when they sync up, they will retrieve the Global Address List? In news:%23TkYtT0$GHA.3560@TK2MSFTNGP04.phx.gbl, Flip <phil.atkinson@beltek.com> typed: > We use Ipaqs throughout the company, and I was wondering if there is > anyway to have exchange add the GAL to the outlook contacts on the > workstation, so that when they sync up, they will retrieve the Global > Address List? No (and this wouldn't really be an ...

Removing Page Number from Final Page- Publisher 2002
Dear Mary Sauer: I used the header function to page number my newsletter. I got rid of the page number from the first page. How do I eliminate it from the back (last) page. Iused the text box tip to do the former. Thanks Barry Create a rectangle, fill with white, no line. Cover the page number. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Barry" <cbj97@yahoo.com> wrote in message news:uJ2EE$R3GHA.1608@TK2MSFTNGP04.phx.gbl... > Dear Mary Sauer:...

Fields in items list-- add/delete
Hai, I am using RMS version 1.2. In Stores Operations Manager it displays list of items when click on Database-->Items. It displays only five columns. Now i need to add / delete some fields in this list. Is it possible to add or delete the fields? if yes how can i add the fields? Thanks in advance, Nagendra On Wed, 27 Apr 2005 01:22:02 -0700, "Nagendra" <Nagendra@discussions.microsoft.com> wrote: >Is it possible to add or delete the fields? if yes how can i add the fields? I don't think so antonio ...

Mac 98 Word page numbers
The page number command has disappeared from insert command. How to reinstall it? ...

remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has about 6,000. I need to remove the 6,000 from the 16,000 as they all appear in the big list as well. How do I extract those 6,000 entries from the larger list? My expected result is a mailing list with 10,000 names. Chip Pearson has some techniques at: http://www.cpearson.com/excel/duplicat.htm Howie J. wrote: > > I have two mail lists on excel. The first has 16,000 names, the second has > about 6,000. I need to remove the 6,000 from the 16,000 as they all appear > in the big list as well. How do ...

format of numbers in a downloaed file
I have a peculiar (atleast to me) problem,. I get some bills account from my consultant. This is not in a webpage nor as an email message nor as an attachment to an email message. I get these bills in the special software which he has introduced in my computer. But when I < selectall> the entries in the file and copy to an excel spreadsheet it serves the prupose mostly. But some numbers are in a strange format neither as numbers, nor as text but in some format such that I am not able to do calclations on these "numbers". I know how to convert a number in text format into num...

To-do list
In Outlook 2007, I can't find a way to show a short summary of my e-mail inbox on my Calendar page, similar to the way Outlook shows a To-do list of calendar items on my Mail page. It would save me a lot of switching back and forth. If there is a way, please tell me. If not, maybe you could consider adding it to the next version of Outlook. Otherwise, I love the program. -- BB ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the mes...

exception list
where can I find the exception list for intelligent message filtering? Global Settings in ESM Nue "jlconley" <jlconley@discussions.microsoft.com> wrote in message news:DDF580F1-71C4-4A59-B502-5736266E74AD@microsoft.com... > where can I find the exception list for intelligent message filtering? Not sure what you mean - there's no exception list as such. You can insert IP addresses of known/trusted hosts (from customers/partners and such.. ) in Connection Filtering's Global Accept/Deny lists and these will bypass all other filters. Will need to enable Connect...

Conditional Formatting w/ a List/Icons
I am trying to allow someone to select "Green", "Yellow" or "Red" from a list and the cell to display a green/yellow/red icon appropriately. Or, if possible, the user could just select the icon (instead of selecting text). Is this possible? Use Data Validation for the list. Type in Red, Yellow, Green as the list. This give the user the list to select from. Use Conditional Formatting for the fill part. Set three conditions, If Cell Value-"Green" (select a green fill), etc.. -- If this helps, please remember to click yes. "...