Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom
I will have a column of nine digit numbers. The first six digits are 999999;
the last three digits will vary. How do I format the column so I just have to type in the last three digits and the first six will fill with 9s automatically? I tried custom 999999###. That works where the last three digits are 101, for example. However it doesn't work where the last three digits are 007. I get 9999997. It doesn't pick up 00. Thanks, -- Howard |
#2
|
|||
|
|||
Howard
This one works for me. Custom 999999000 Enter 007 and return 999999007 Gord Dibben Excel MVP On Thu, 24 Mar 2005 11:45:14 -0800, Howard wrote: I will have a column of nine digit numbers. The first six digits are 999999; the last three digits will vary. How do I format the column so I just have to type in the last three digits and the first six will fill with 9s automatically? I tried custom 999999###. That works where the last three digits are 101, for example. However it doesn't work where the last three digits are 007. I get 9999997. It doesn't pick up 00. Thanks, |
#3
|
|||
|
|||
Thanks, Gord!
HF "Gord Dibben" wrote: Howard This one works for me. Custom 999999000 Enter 007 and return 999999007 Gord Dibben Excel MVP On Thu, 24 Mar 2005 11:45:14 -0800, Howard wrote: I will have a column of nine digit numbers. The first six digits are 999999; the last three digits will vary. How do I format the column so I just have to type in the last three digits and the first six will fill with 9s automatically? I tried custom 999999###. That works where the last three digits are 101, for example. However it doesn't work where the last three digits are 007. I get 9999997. It doesn't pick up 00. Thanks, |
#4
|
|||
|
|||
Instead of formatting, have you thought of changing the value?
You can put 999999000 in a cell. copy that cell select your range to adjust and edit|paste special|Check add Clean up that cell with 999999000 I find that sometimes the way the cell is displayed is nice, but not sufficient for lots of stuff. =if(a199999000,"x","y") would be the kind of thing that would drive me nuts if I saw 999999007 in A1! Howard wrote: I will have a column of nine digit numbers. The first six digits are 999999; the last three digits will vary. How do I format the column so I just have to type in the last three digits and the first six will fill with 9s automatically? I tried custom 999999###. That works where the last three digits are 101, for example. However it doesn't work where the last three digits are 007. I get 9999997. It doesn't pick up 00. Thanks, -- Howard -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
How to automate custom footer on all tabs | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
Custom Type Charts Problem | Excel Worksheet Functions |