There's a some issue. When I enter data value with "0", automatically, it is discarded initial "0" value. Then, it is shown as one digit number and it is displayed as error.
Ex: when I add date as 04/06/2018, automatically excel converts it into 4/6/2018 and it is shown as invalid data.
When I add date as 23/04/2019, automatically excel converts it into 23/4/2019 and it is shown as invalid data.
Everything is working properly, how do I avoid this automatic conversion.
Bookmarks