Hi, is there a way to have data validation on a column, possibly a custom way / formula, that a user has to input the refernce in this format 11111.11.11.11 with the decimal seperators, its the end of the account number first and then todays date at the end 12345.01.06.20. I have tried, but my lack of Excel skills have me failing.
Any help would be grately appreciated.
Any help would be grately appreciated.