Leading zero

[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

 

[Andy]

Robert

You could format the cell to Number 000000. This would keep the leading
zero.

Andy

 

[Anon]

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

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

 

[Dave Peterson]

How about changing
020
to
'030
(leading apostrophe)