Find and replace won't replace a parenthesis by nothing without changing the cell format

[Arzock]

Hello everyone,

I'm using the "find and replace" feature in excel 365 and I'd like to replace a parenthesis by nothing, in order to get rid of it. But everytime I try to do that, the cell format change to date and time and modifies the content of said cell, even if I select the text format before hand.

 If I try do select text format like so :

It act like it's all good and done but nothing changes ...

So my question is : WHY ? does such thing happen ?

Cheers

[#2]

@Arzock 

The semicolon make Excel think you are entering a time. Try this:

=LEFT(<cell>,LEN(<cell>)-1)

.... and then copy /paste values.