Ask Experts Questions for FREE Help !
Ask
    nanc1430's Avatar
    nanc1430 Posts: 106, Reputation: 1
    Junior Member
    		  
    #1

    Oct 5, 2008, 10:45 PM
    Changing numbers automatically in excel
    I have excel 2000 on my computer and downloaded a free invoice template.
    Over on the upper right it says invoice and then a blank for you to fill it in.
    I filled in a number and wanted to know if there is any way to have the invoice number change as I use the invoices without doing it manually?
    Thank you
    nanc1430
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Oct 5, 2008, 10:49 PM

    This web page shows two ways to do this exact thing:

    McGimpsey & Associates : Excel : Sequential numbers
    nanc1430's Avatar
    nanc1430 Posts: 106, Reputation: 1
    Junior Member
    		  
    #3

    Oct 6, 2008, 12:45 AM
    Thank you very much. I have been trying to do this all day.
    nanc1430
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

MS Excel spreadsheet changing numbers [ 4 Answers ]

I have a spreadsheet where I enter credit card numbers, 16 digits. One note, I have the field setup as a custom format, that displays in the custom format as ####-####-####-####. This way it automatically adds the 4 dashes. For some reason, it always changes the last digit to zero. For...

Excel: Convert numbers to date [ 4 Answers ]

I'm using excel 07 and I have a cell containing the number 11291997 which represents 11/29/1997. How can I convert this to a date format. The 11291197 is number formatted. Any suggestions would help, thanks!

Count in excel excluding repeating numbers [ 1 Answers ]

Is there a way for me to count in a column and exclude numbers that repeat? I am working a spreadsheet with account numbers and need to count how many account numbers... the problem is that some of them repeat within the spreadsheet. Can someone help? Thanks in advance!

Auto Generating Sequential Numbers in Excel 2003 [ 2 Answers ]

Hello All I would like to have sequential Auto Generated Numbers in column A of my Excel 2003 Spreadsheets e.g A1=1, A2=2, A3=3 etc. But I would like Excel to auto generate this number, rather than input?

Padding numbers in excel [ 2 Answers ]

I have about 500,000 cells on a spreadsheet that all follow a letter and number pattern. There are two patterns that look like this: y124f07 and h67g02. So the first is: Letter, number, number, number, letter, number, number The second is: Letter, number, number, letter, number, number

View more questions Search