Strikethrough not able remove

[rkeshvani]

Hi,

I have received some data in excel which has couple of column specially Date and Amount which are strikethrough, I am trying to remove from Format Cell / Fonts / strikethrough (unchecked) but it strikethrough is not removing.

Please advice on above query.

Thank you.

 

[Hermanito]

it might be that the strikethrough is applied by using conditional formatting...

 

[rkeshvani]

it might be that the strikethrough is applied by using conditional formatting...

Thanks for reply, but how to remove it??? I have gone though conditional formatting but found nothing in it.

 

[Hermanito]

you can easily test if it's due to conditional formatting:
- select one or more of the cells with the problem
- press CTRL+C
- rightclick an empty cell somewhere and choose PasteSpecial
- select Values in the PasteSpecial dialog

is the strikethrough still applied to the copied cells now?

EDIT: I just realised this would remove the strikethrough also when it is applied directly on the font, not just for conditional formatting

 

[rkeshvani]

you can easily test if it's due to conditional formatting:
- select one or more of the cells with the problem
- press CTRL+C
- rightclick an empty cell somewhere and choose PasteSpecial
- select Values in the PasteSpecial dialog

is the strikethrough still applied to the copied cells now?

EDIT: I just realised this would remove the strikethrough also when it is applied directly on the font, not just for conditional formatting

Thanks for reply,
I have tried this also but it is not happening. even I have pasted in new sheet still same error.

 

[Hermanito]

even with PasteSpecial/Values you still have it as strikethrough??
That is just weird...

Are you sure someone has not been messing around with your fonts, as a prank?

 

[rkeshvani]

even with PasteSpecial/Values you still have it as strikethrough??
That is just weird...

Are you sure someone has not been messing around with your fonts, as a prank?

Yes Dear, even using PasteSpecial value it is not removing anything. it is weird in reality. anyone have this answer please.

 

[Hermanito]

Can you post the workbook somewhere for download? I would like to have a look myself...