Custom cell formatting

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
......
 
T

Trevor Shuttleworth

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
 
T

Trevor Shuttleworth

Oops ;-(

Might help if I gave you the format !

000000;000000;000000;@

Regards

Trevor
 
M

MDavison

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
 

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

Bigger Problem 0
Formatting Time As hhmmss Gives Me Dates Instead? 3
VLOOKUP, a table with text and numerics 7
Conditional formatting based on formula cell 4
Conditional Formatting from a group 6
Need to create an incremental sequence number 3
How do I format cells as custom and keep text formatting? 2
Office 2007 + formatting cells 1

Top