Preventing auto-formatting when Replacing

[Frank Marousek]

Say I have a cell that contains

LED2/14

The cell is formatted as Text.

If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting
the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to prevent this
infuriating behavior?

Thanks,
Frank

 

[Dave Peterson]

How about:
Edit|Replace
LED
with
'
(apostrophe)

Say I have a cell that contains

LED2/14

The cell is formatted as Text.

If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting
the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to prevent this
infuriating behavior?

Thanks,
Frank

 

[RagDyer]

Instead of replacing with nothing, try replacing with APOSTROPHE (').
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Say I have a cell that contains

LED2/14

The cell is formatted as Text.

If I use Ctrl-H to replace LED with nothing, Excel insists on reformatting
the remaining 2/14 as a date (i.e. 14-Feb). Is there any way to prevent this
infuriating behavior?

Thanks,
Frank

 

[Frank Marousek]

That works great, thanks guys.

Frank