Custom cell formatting

  • Thread starter Thread starter MDavison
  • Start date Start date
M

MDavison

I need to create a custom format for a series of cells that will begin like
this.
I can't figure out what the code character is fora volitile potentially
alpha character.
Can anyone help me??
-Monica, Dallas

000000
000001
000002
....
000009
00000A
00000B
000010
000011
......
 
Monica

something like this might work for you but you'll need to put all the
leading digits in for the entry with the alpha character

Regards

Trevor
 
Oops ;-(

Might help if I gave you the format !

000000;000000;000000;@

Regards

Trevor
 
Well - that sort of helped. But the alpha characters are not autofilling as
needed -
A, B, A1, B1, A2, B2....when I fill the series , they all enter as simply A
& B, with the preceeding zeroes.
Maybe this one just doesn't want to work?
-M
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 2007 + formatting cells 1
Format Cells for Hexidecimal (custom?) 1
Formatting Time As hhmmss Gives Me Dates Instead? 3
Need to create an incremental sequence number 3
Formatting cells with time 3
Conditional formatting based on formula cell 6
custom number format 1
Custom cell format for percentage 3

Back
Top