| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Characters in a cell
I need a macro that will look at a cell and if it only has one character then add zero's in front of it until it has 3 characters.
Example: if cell "A1" = "10" then the macro would make it say "010" if cell "A1" = "BA" then the macro would make it say "0BA" Is there a setting that looks at the number of characters??? Thanks, Kevin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
| Need to use only 14 characters in cell | Excel Discussion (Misc queries) | |||
| Transfer specific characters from cell to another cell. | New Users to Excel | |||
| Need more characters in a cell | New Users to Excel | |||
| cell max characters | Excel Discussion (Misc queries) | |||
Threaded Mode
