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