Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to write a small macro that will accomplish the
following. I am working with a column of numbers (as text) they are zip codes. The zipcodes that begin with zero have had their starting zero removed by the program in which they were initially stored. I need to insert a zero in front of any zipcode that has only 4 characters. Here is what I am currently doing in an active cell like [2345] [F2] to go into edit mode [Home] to move to the front of the string [0] to insert the "0" at the front of the string [Enter] to go down to the next cell. I want to create a keystroke macro that is faster Any ideas. Thanks Lowell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric? | Excel Worksheet Functions | |||
insert "-" as fourth character in number string | Excel Discussion (Misc queries) | |||
Does the cell contain the character "-" within the string? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |