Excel swapping data to a date

Copper Contributor

Hello,

I have  one cell in an xlsx worksheet that changes any data input to a random date on save. There are no formulae attached and as far as I can see, no other fomatting in the cell. All other cells behave ok.

Can anyone help?

Thanks

3 Replies

@pottsdie136 

 

use '  in front of the 1st character

@Ramiz_Assaf 

 

all sorted now thanks, not sure what was happening with it last week.

Please share the Workbook to examine the cell to fix it !!