Question - query re repeating numbers in rows

[cerna]

Dear colleagues,

I need some help please....

I have a sheet and I would like to repeat numbers in the same column in this following series:

10001-12
10002-12
10003-12
10004-12
10005-12
10006-12


with the 12 being the year..

Any advise would be greatly aprpeciated as I am new to this.

thanks in advance

[tom1977]

Hi

maybe use such custom format 0"-12"

[cerna]

Hi

maybe use such custom format 0"-12"

Hi Tom,

Thanks. how can I use this...in a formula?

[tom1977]

Sorry my fault this is not formula this is format of cell
After using of this format type into cell A1 10001 and into A2 10002 then select both cells and drag it down

[cerna]

Sorry my fault this is not formula this is format of cell
After using of this format type into cell A1 10001 and into A2 10002 then select both cells and drag it down

Dear Tom,

thanks!

One query I would like to have the liberty to be able to change 12 to 13 next year in the same coulumn.

Form what I understand if I adjust the formatting it will apply just the 12 right to all enties?

Thanks and much appreciate the help.

[Marcol]

Try this in A2, with your year in B1

Please Login or Register  to view this content.

Drag/Fill Down

Select the required year from the drop-down in B2