| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I auto format data so that the middle letter changes. EG 2.
I am trying to set up an exel spread sheet so that I can change the data by
dragging down instead of re-typing each one, so for example I want accross the top to be: 21A01 21A02 21A03 etc which I can just drag and it will automatically change the number digit but I am trying to change the down collum to read 21A01 21B01 21C01 etc etc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Capital Letter in a cell | Excel Worksheet Functions | |||
| Auto capital letter in a cell | Excel Worksheet Functions | |||
| How do I set a drop-down to auto-pop. by typing first letter? | Setting up and Configuration of Excel | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| Auto format rows according to field data | Excel Discussion (Misc queries) | |||
Threaded Mode
