Code to insert current date (but NOT current time)

Friends,

I am creating a macro that will insert the current date on a spreadsheet. I used this code:

Please Login or Register  to view this content.

The problem is that I only want the date ... not the time showing at all. This is important because the spreadsheet is going to be saved as a CSV and imported into another program. Importing the time would be a problem.

Can you help?

Thank you so much!
Mike

Hi Mike,

use this :

Please Login or Register  to view this content.

You could also still add in (before the end sub) :

Please Login or Register  to view this content.

and play around with that to get the format you want.

Please click the * below if this helps

Thank you very much!!