| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom cell formatting
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 ...... |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom cell formatting
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 "MDavison" wrote in message ... 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 ..... |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom cell formatting
Oops ;-(
Might help if I gave you the format ! 000000;000000;000000;@ Regards Trevor "Trevor Shuttleworth" wrote in message ... 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 "MDavison" wrote in message ... 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 ..... |
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom cell formatting
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 "Trevor Shuttleworth" wrote in message ... Oops ;-( Might help if I gave you the format ! 000000;000000;000000;@ Regards Trevor "Trevor Shuttleworth" wrote in message ... 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 "MDavison" wrote in message ... 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 ..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
| Cell Custom Formatting | Excel Worksheet Functions | |||
| custom cell formatting | Excel Discussion (Misc queries) | |||
| Custom Cell Formatting | Excel Programming | |||
| Custom Cell Formatting | Excel Programming | |||
Hybrid Mode
