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 EditPaste 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

Pages: 1 Prev: How to reference a spacific cell in multiple saved excel files. Next: gridlines in pivot table 