Pop Up Window/Message

[DharmeshChauhan]

Hi

I currently have a spreadsheet whereby clients are entering date of births as 12.02.2022 or 12/02/2022

I require this information to be in this format 12-02-2022, is there a way of automatically converting this once the client has entered the DOB and moved on to the next cell, or can a warning/pop up message be displayed every time they click on the cell that would inform them to enter the DOB in a certain way

Thanks In Advance

Dharm

 

[DharmeshChauhan]

Hi

@mumps, were you able to look at this? or can anyone else help me out

Thanks In Advance