ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,227
- Office Version
- 2007
- Platform
- Windows
Hi,
For some time now & still unable to find the cause im asking if there is a vba code etc for which will check & alter the date.
The worksheet is called DATABASE
The date will always be in column N
The first row this applies to is Row 5
My issue is sometimes i paste or typr the day like so into the cell 09/02/2023
For some reason its changed to 02/09/2023
Its not always noticed at first but then sometime down the road when checking a customers file then its noticed.
Example.
My database shows the part being out of warranty but when the customer shows me the receipt the date is different.
Looking on the databse then confirms he is correct & my date in the column is wrong.
Hence why a code that if the date in column N is MM/DD/YYY then change it to DD/MM/YYY
Thanks please advise
For some time now & still unable to find the cause im asking if there is a vba code etc for which will check & alter the date.
The worksheet is called DATABASE
The date will always be in column N
The first row this applies to is Row 5
My issue is sometimes i paste or typr the day like so into the cell 09/02/2023
For some reason its changed to 02/09/2023
Its not always noticed at first but then sometime down the road when checking a customers file then its noticed.
Example.
My database shows the part being out of warranty but when the customer shows me the receipt the date is different.
Looking on the databse then confirms he is correct & my date in the column is wrong.
Hence why a code that if the date in column N is MM/DD/YYY then change it to DD/MM/YYY
Thanks please advise