From: Gazz_85 on 4 Mar 2010 08:49 I have over 400 entries in a colomn which start with 0015...and then more numbers. how can easily edit on mass so that they now begin with only 015 ??? cheers From: Mike H on 4 Mar 2010 08:58 Hi, To get these leading zeroes there are 2 likely possibilities:- 1. The cells are formatted to show them so simply alter the format. or 2. The numbers are really text and I have assumed this is the case. So if the 'numbers' start in a1 put this in b1 and drag down =RIGHT(A1,LEN(A1)-1) Copy this new range and then select the 'old' range and Edit|Paste special - select values - OK delete the column with the formula in. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Gazz_85" wrote: > I have over 400 entries in a colomn which start with 0015...and then more > numbers. > > how can easily edit on mass so that they now begin with only 015 ??? > > cheers From: Bob I on 4 Mar 2010 09:06 If there are no other instances of "00" you could use Find, Replace "00", "0" Gazz_85 wrote:> I have over 400 entries in a colomn which start with 0015...and then more > numbers. > > how can easily edit on mass so that they now begin with only 015 ??? > > cheers  |