Preventing auto-formatting when Replacing

  • Thread starter Thread starter Frank Marousek
  • Start date Start date
F

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
 
How about:
Edit|Replace
LED
with
'
(apostrophe)

Frank said:
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
Click to expand...
 
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
 
Back
Top