Excel keeps changing date to text

%3CLINGO-SUB%20id%3D%22lingo-sub-1072970%22%20slang%3D%22en-US%22%3EExcel%20keeps%20changing%20date%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1072970%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20form%20that%20customers%20need%20to%20fill%20out%20and%20import%20to%20our%20website.%20We%20ask%20for%20dd%2Fmm%2Fyyyy%20format%20date.%20We've%20had%20no%20issues%20with%20this%20until%20this%20summer%2C%20when%20excel%20mysteriously%20began%20changing%20the%20above%20format%20into%20text.%20I've%20used%20the%20custom%20and%20date%20options%20in%20the%20cell%20format%20panel%20(selecting%20dd%2Fmm%2Fyyy).%20I've%20used%20the%20text%20to%20columns%20trick%20which%20works%20initially%2C%20but%20it%20doesn't%20stick.%20If%20you%20try%20to%20then%20clear%20that%20date%20and%20enter%20a%20new%20one%2C%20it%20reverts%20back%20to%20text.%20I've%20tried%20setting%20the%20language%20to%20UK%20English%20in%20the%20options%20panel%20but%20again%2C%20it%20works%20initially%2C%20but%20then%20if%20I%20try%20to%20then%20enter%20a%20new%20date%20it%20reverts%20back%20to%20text.%20Any%20advice%20would%20be%20great.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1072970%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-1073063%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20keeps%20changing%20date%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1073063%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F493214%22%20target%3D%22_blank%22%3E%40rs2282%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20post%20a%20screenshot%20like%20this%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F162388i01F036610E1F81F9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a form that customers need to fill out and import to our website. We ask for dd/mm/yyyy format date. We've had no issues with this until this summer, when excel mysteriously began changing the above format into text. I've used the custom and date options in the cell format panel (selecting dd/mm/yyy). I've used the text to columns trick which works initially, but it doesn't stick. If you try to then clear that date and enter a new one, it reverts back to text. I've tried setting the language to UK English in the options panel but again, it works initially, but then if I try to then enter a new date it reverts back to text. Any advice would be great. Thanks!

1 Reply
Highlighted

Hi @rs2282 

 

Can you post a screenshot like this

 

clipboard_image_0.png