Hi

This one has me confused

When the data in the Cell is "xxxx: 05555" the result following the replace is "5555" where I would expect " 05555" , I would appreciate any Ideas to fix this;


ActiveSheet.Columns("B").NumberFormat = "@"
ActiveSheet.Columns("B").Replace What:="*:", Replacement:=""


Thanks Kev ( using Excel 2003 )