RE: Repeating formula in Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: tjtjjtjt (tjtjjtjt_at_discussions.microsoft.com)
Date: 11/27/04 

Date: Fri, 26 Nov 2004 17:37:01 -0800

One way:
Delete the dash from your number.
Select the cell with the number.
Go to Format | Cells | Number.
Choose Custom and type:
0000-000
click okay.
Then, (still with the same cell selected) go to Edit | Fill | Series.
Make sure the Step Value is 1.
Change to Columns and put a stop value of 2005550.
Click okay.

tj

"RescueEMT72" wrote:

> Hi. I need to copy a number into 500 rows, with each number increasing by 1
> in value. These numbers are used to track call numbers, so the format is
> like this: 2005-001 and I need it to repeat itself up to 2005-0550, and I
> don't want to spend the time typing each value in manually. Someone please
> help!!!

Relevant Pages

  • RE: Repetive Formatting/Creating a Toolbar button
    ... then click and drag "Custom Menu Item" into the tool bar you created. ... Now you need to create a Macro, press Atl+F11 to open the VBA Window ... I work on different worksheets all of the time and have to choose format (on ... different cells specific font withing the cell). ...
    (microsoft.public.excel.misc)
  • Re: Multiple Questions about adding different cells
    ... Then apply the same custom number format to the cell that holds the MAX ... Microsoft Excel MVP ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Align Left and Right in Same Cell
    ... suggest to get the same thing without using a custom number format. ... Say I want "Patrick Stewart" to look like this... ... I enter Patrick in the cell and then apply the following custom number ...
    (microsoft.public.excel.misc)
  • Re: Excel 07 - text displays as pound signs
    ... If I typed a number in that cell, ... surprised seeing the scientific format. ... Excel 07 - text displays as pound signs ... "Dave Peterson" wrote: ...
    (microsoft.public.excel.newusers)
  • Re: Dual Formatting in Macro
    ... based on a key cell DP placement. ... just have it formatted for custom all the time for the + and - prefix, ... format for + and - numbers each time? ... Dim KeyCell As Range, AnswerCell As Range ...
    (microsoft.public.excel.worksheet.functions)