Sequential Number Formula

[Paul Skinner]

Excel 10.1.6, Tiger 10.4.2, G5
Running a huge database on horse racing and would like a unique sequence
Number corresponding to date, race number and horse number.
Tried =CONCATENATE(B4,D4,G4)--- (B4=Date, D4=Race number, G4=Horse number)
Falls short when race or horse number >9, Unable to sort in sequential order
E.g. Date number =36527 + Race number 6 + Horse number 4, =3652764
Date number =36527 + Race number 6 + Horse number 10, =36527610
Would like formula to to insert a 0 in front of all single numbers. So
formula result would read =36527604, same length as two digit numbers
paul

 

[JE McGimpsey]

Excel 10.1.6, Tiger 10.4.2, G5
Running a huge database on horse racing and would like a unique sequence
Number corresponding to date, race number and horse number.
Tried =CONCATENATE(B4,D4,G4)--- (B4=Date, D4=Race number, G4=Horse number)
Falls short when race or horse number >9, Unable to sort in sequential order
E.g. Date number =36527 + Race number 6 + Horse number 4, =3652764
Date number =36527 + Race number 6 + Horse number 10, =36527610
Would like formula to to insert a 0 in front of all single numbers. So
formula result would read =36527604, same length as two digit numbers

One way:

=B4 & TEXT(D4,"00") & TEXT(G4,"00")

which would produce 365270604

 

[Paul Skinner]

One way:

=B4 & TEXT(D4,"00") & TEXT(G4,"00")

which would produce 365270604

Thanks for quick reply, works perfectly