Excel swapping data to a date

%3CLINGO-SUB%20id%3D%22lingo-sub-1738303%22%20slang%3D%22en-US%22%3EExcel%20swapping%20data%20to%20a%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1738303%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%26nbsp%3B%20one%20cell%20in%20an%20xlsx%20worksheet%20that%20changes%20any%20data%20input%20to%20a%20random%20date%20on%20save.%20There%20are%20no%20formulae%20attached%20and%20as%20far%20as%20I%20can%20see%2C%20no%20other%20fomatting%20in%20the%20cell.%20All%20other%20cells%20behave%20ok.%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1738303%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1742394%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20swapping%20data%20to%20a%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1742394%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F817486%22%20target%3D%22_blank%22%3E%40pottsdie136%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Euse%20'%26nbsp%3B%20in%20front%20of%20the%201st%20character%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 !!