Copy paste cell mistake between .ods und .xlsm

Hi, in a nextcloud-collabora instance i recently copy-pasted the content of an cell from a .odt file into a .xlsm file. The pasted cell was copied over, however

  1. with a wrong formatting (instead of the value “4700”, it shows now “_(€ 4,700.00 _)”
  2. it turned out it was a protected cell, property that was copied over in a protected sheet and now cannot be edited.

what is the best procedure to solve this?
thanks