Excel Date issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2012213%22%20slang%3D%22en-US%22%3EExcel%20Date%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2012213%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20insert%20data%20from%20a%20delimited%20note%20pad%20file%2C%20the%20date%20in%20the%20data%20is%20as%20%2220-May-30%22%20but%20after%20pasting%20the%20excel%20shows%20date%20in%20formula%20bar%20as%20%2220-May-1930%22%20and%20when%20i%20just%20type%20date%20as%20m%2Fd%2Fyy%20%225%2F20%2F30%22%20formula%20bar%20shows%205%2F20%2F2030%2C%20i%20have%20already%20changed%20the%20date%20setting%20in%20system%20but%20it%20is%20only%20working%20when%20I%20type%20the%20date%20not%20when%20it%20come%20through%20delimited%20option.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2012213%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2012574%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Date%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2012574%22%20slang%3D%22en-US%22%3EHow%20are%20you%20importing%20the%20file%20into%20Excel%20exactly%3F%3C%2FLINGO-BODY%3E
New Contributor

When I insert data from a delimited note pad file, the date in the data is as "20-May-30" but after pasting the excel shows date in formula bar as "20-May-1930" and when i just type date as m/d/yy "5/20/30" formula bar shows 5/20/2030, i have already changed the date setting in system but it is only working when I type the date not when it come through delimited option.

2 Replies
How are you importing the file into Excel exactly?

@Jan Karel Pieterseinternal system generate data file in notepad I copy paste it from notepad file and delimited by ", Comma".