Leading zero

  • Thread starter Thread starter Robert Dieckmann
  • Start date Start date
R

Robert Dieckmann

I format a column to text and type a series of items, each of which have a
leading zero. So far so good. If I have to do a mass edit on these items,
using find & replace (Ctrl+H) it automatically drops the leading zero.

Example: Column A contains the following:
020003
020004
020005

I need to change these to 030003, 030004 & 030005
I replace 020 with 030 and now Column A looks like this:

30003
30004
30005

How do I keep my leading zeros?

Rdd
 
Robert Dieckmann said:
I format a column to text and type a series of items, each of which have a
leading zero. So far so good. If I have to do a mass edit on these items,
using find & replace (Ctrl+H) it automatically drops the leading zero.

Example: Column A contains the following:
020003
020004
020005

I need to change these to 030003, 030004 & 030005
I replace 020 with 030 and now Column A looks like this:

30003
30004
30005

How do I keep my leading zeros?

Rdd
Click to expand...

Replace with '030 instead of just 030.
(That's an apostrophe before the 030.)
 
Back
Top