How to Remove =date(2020,10,11) function from spreadsheet.

%3CLINGO-SUB%20id%3D%22lingo-sub-1806211%22%20slang%3D%22en-US%22%3EHow%20to%20Remove%20%3Ddate(2020%2C10%2C11)%20function%20from%20spreadsheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1806211%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20use%20the%20date%20in%2010%2F11%2F2020%20format%20only.%26nbsp%3B%26nbsp%3B%20The%20%3Ddate%20is%20obtained%20from%20another%20program%20that%20I%20need%20to%20use%20but%20need%20to%20change.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1806211%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1807331%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Remove%20%3Ddate(2020%2C10%2C11)%20function%20from%20spreadsheet.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1807331%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F841407%22%20target%3D%22_blank%22%3E%40Christal213%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20is%20no%20link%20between%20the%20function%20and%20date%20format.%20Dates%20in%20Excel%20are%20just%20sequential%20integer%20number%2C%20and%20format%20is%20only%20to%20make%20them%20more%20familiar%20for%20human%20being.%20Manually%20you%20may%20add%20date%20in%20it's%20format%20and%20i%20behind%20Excel%20converts%20it%20to%20integer.%20In%20opposite%20function%20returns%20an%20integer%20and%20Excel%20shows%20it%20in%20applied%20to%20the%20cell%20format.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'd%20recommend%20to%20use%20DATE()%20to%20avoid%20issues%20with%20locale%20formats.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I need to use the date in 10/11/2020 format only.   The =date is obtained from another program that I need to use but need to change.

1 Reply
Highlighted

@Christal213 

There is no link between the function and date format. Dates in Excel are just sequential integer number, and format is only to make them more familiar for human being. Manually you may add date in it's format and i behind Excel converts it to integer. In opposite function returns an integer and Excel shows it in applied to the cell format.

 

I'd recommend to use DATE() to avoid issues with locale formats.