Leading Zero Sums?!

snowball

New Member
Joined
Dec 19, 2005
Messages
1
I need to create a list of numbers in the following format:

0001/01
0001/02
0001/03
0001/04
0001/05
0002/01
0002/02
0002/03

(Range from 0001/01 to 3600/05)

and so on and so forth, but cannot find a way to create this in Excel!

I'm quite a noob to excel, so anyones expertise would be greatly appreciated!

Many thanks
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Welcome to the board!


Try:

=TEXT(INT((ROW()+4)/5),"0000")&"/"&TEXT(MOD(ROW()-1,5)+1,"00")

in A1 and drag down.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,013
Messages
5,569,620
Members
412,283
Latest member
camgree
Top