Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Zero Filling
What is the best way to increment the rows of a column,
while maintaining zero filling Thanks in advance |
#2
|
|||
|
|||
Hi
not really sure what you're trying to do. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... What is the best way to increment the rows of a column, while maintaining zero filling Thanks in advance |
#3
|
|||
|
|||
Want to # the rows as they came in to us, before working
with the file. So if the 1st row is given the 'id' of 0001, I want each row after that to increment by one, but wish to keep the lead zeros - up to say 0999 (they are necessary for some of our other programs). -- 0001 0002 0003 etc -----Original Message----- Hi not really sure what you're trying to do. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... What is the best way to increment the rows of a column, while maintaining zero filling Thanks in advance . |
#4
|
|||
|
|||
Fi
format the cells with a custom format such as 0000 -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... Want to # the rows as they came in to us, before working with the file. So if the 1st row is given the 'id' of 0001, I want each row after that to increment by one, but wish to keep the lead zeros - up to say 0999 (they are necessary for some of our other programs). -- 0001 0002 0003 etc -----Original Message----- Hi not really sure what you're trying to do. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... What is the best way to increment the rows of a column, while maintaining zero filling Thanks in advance . |
#5
|
|||
|
|||
Try entering in A1.......=ROW()
Then drag/copy down Column A. Select Column A and FormatCellsNumberCustom Enter 0000 in the dialog box. Gord Dibben Excel MVP On Fri, 17 Dec 2004 10:08:47 -0800, wrote: Want to # the rows as they came in to us, before working with the file. So if the 1st row is given the 'id' of 0001, I want each row after that to increment by one, but wish to keep the lead zeros - up to say 0999 (they are necessary for some of our other programs). -- 0001 0002 0003 etc -----Original Message----- Hi not really sure what you're trying to do. Could you give an example? -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ... What is the best way to increment the rows of a column, while maintaining zero filling Thanks in advance . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filling a series | Excel Discussion (Misc queries) | |||
Filling drop down box | Excel Discussion (Misc queries) |