Number Assignment
 

One of my headers is Account Number and the account number has seven
characters, three alpha and four numeric. Is there a way after assigning the
alpha characters to allow excel to automatically assign the four numeric
characters in a sequence of 2?

Example Account Number: SSB0012
SSB0014

Thanks
--
GRK

Number Assignment
 

One guess, one play ..
Try in any starting cell, say in B2:
="SSB"&TEXT(ROWS($1:1)*2-2,"0000")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GRK" wrote:
One of my headers is Account Number and the account number has seven
characters, three alpha and four numeric. Is there a way after assigning the
alpha characters to allow excel to automatically assign the four numeric
characters in a sequence of 2?

Example Account Number: SSB0012
SSB0014

Thanks
--
GRK

Number Assignment
 

Max,

Thanks, it worked.
--
GRK


"Max" wrote:

One guess, one play ..
Try in any starting cell, say in B2:
="SSB"&TEXT(ROWS($1:1)*2-2,"0000")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GRK" wrote:
One of my headers is Account Number and the account number has seven
characters, three alpha and four numeric. Is there a way after assigning the
alpha characters to allow excel to automatically assign the four numeric
characters in a sequence of 2?

Example Account Number: SSB0012
SSB0014

Thanks
--
GRK

Number Assignment
 

Welcome, good to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GRK" wrote in message
...
Max,
Thanks, it worked.
GRK