Hi All,

I have a user form we are using to transfer data into an excel spread sheet. When transferring the date from a text field it is formatted as general, I need this to be a date format DDMMYYY. Does anyone know the code to do this? The cell needing formatting is N2

Thanks

Katie