| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to delete a specific sign
Hi Gary
Thanks ever so much - it worked and it worked fast! -- LEG-denmark "LEG" wrote: Hi! I have two systems which deliver the samme ID-number in two different formats. 1. 080808-0000 with the format Tekst 2. 0808080000 with the format "number saved as tekst" no. 2 is easy enough in the 2007 version to change to a numberformat. In the case of no. 1 can someone help to find a macro that would automatically delete the '-', and change the format to numbers. As I have a list of 2000 ID-no. it would take some time to delete the '-' manuelly. Any help would be appreciated. -- LEG-denmark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to keep specific name colomns and delete all others | Excel Discussion (Misc queries) | |||
| Macro to delete specific cells | Excel Programming | |||
| Macro to delete specific rows | Excel Programming | |||
| delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
| Macro to delete specific rows | Excel Programming | |||
Hybrid Mode
