| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding prefix to cell entries
I have some tags that are numbered from
982 00000000 to 982 00000300 I tried using the cell fomat "982 00000"@ to allow me just type in the part that is changing (IE 0 to 300) for ease of use and less errors. My trouble is this doesn't force the extra 0's for tag numbers below 100. Can I do this as it is not a number because of the space. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Prefix | Excel Worksheet Functions | |||
| adding a prefix to cells | Excel Discussion (Misc queries) | |||
| Adding a prefix to all numbers in a column. | Excel Discussion (Misc queries) | |||
| Adding zero prefix to no's | Excel Discussion (Misc queries) | |||
| Adding a prefix to a cell by using a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
