| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding extra digits to columns
I have a column of numbers (isbn for books) which should all have 10 digits.
Somewhere in the copying process some of the numbers have not been formatted as text and have dropped the zero from the beginning of the number. I need to add a zero to the beginning of all the nine digit numbers in the column. How do I achieve this ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup - effect of adding columns | Excel Discussion (Misc queries) | |||
| Adding columns (one with a formula) | New Users to Excel | |||
| Concatenate function - keeping "displayed" extra digits | Excel Discussion (Misc queries) | |||
| how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) | |||
| adding columns | Excel Discussion (Misc queries) | |||
Threaded Mode
