Fix dates when populating on worksheet

User avatar
Doc.AElstein
BronzeLounger
Posts: 1499
Joined: 28 Feb 2015, 13:11
Location: Hof, Bayern, Germany

Re: Fix dates when populating on worksheet

Post by Doc.AElstein »

Thanks
That’s slightly encouraging, I was hoping that 12/1/2021 in the 9th row there would come out OK. Its also date format in that cell, all be it custom. It still comes out OK no matter what I do in any of my computers or excel version, ( although in the formula bar it looks a bit different, - it looks as though Excel tries to make an attempt to put it in the formula bar in my defined system short date format, - on some versions with some short date format it gets it correct, on some it doesn’t. )
makes a mess in the Formula bar.JPG
You do not have the required permissions to view the files attached to this post.
I am having difficulty logging in with this account just now.
You can find me at DocAElstein also