Formating the Date

%3CLINGO-SUB%20id%3D%22lingo-sub-1647462%22%20slang%3D%22en-US%22%3EFormating%20the%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1647462%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20downloaded%20dates%20from%20a%20file%20and%20Excel%20reads%20the%20data%20as%20text.%26nbsp%3B%20I%20have%20tried%20formating%20the%20cells%20to%20be%20a%20date%20but%20Excel%20still%20won't%20see%20the%20format%20as%20a%20date.%26nbsp%3B%20I%20know%20there%20is%20a%20way%20to%20format%20the%20date%20but%20I%20can't%20remember.%3C%2FP%3E%3CP%3ECan%20someone%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1647462%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1647512%22%20slang%3D%22en-US%22%3ERe%3A%20Formating%20the%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1647512%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response%20but%20I%20cannot%20find%20the%20wizard%20mark%20%E2%80%A6%20could%20you%20help%20me%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I have downloaded dates from a file and Excel reads the data as text.  I have tried formating the cells to be a date but Excel still won't see the format as a date.  I know there is a way to format the date but I can't remember.

Can someone help me?

 

 

 

3 Replies

@Shell_NY68 

Just changing format won't help. If dates are in column, you may select them, Data->Text to Columns and on third step of the wizard mark type of the column Date and select in which format they are now (e.g. MDY)

@Sergei Baklan 

Thank you for your response but I cannot find the wizard mark … could you help me again?

@Shell_NY68 

Select the column and Data->Text to Columns. Wizard window appears

image.png

Click Next, Next and on third step

image.png

Result is

image.png

(my dates are in ISO format)