Removing time from a date field

  • Thread starter Thread starter kulalosai
  • Start date Start date
K

kulalosai

There is a date column in my excel spreadsheet. The data in this column
has both date and time. I want to strip off the time part using VBA.
Please let me know if there is an elegant way to do this.

advTHANKSance,
Kirubakaran.

www.kirubakaran.com
 
Hi Don,

Thanks for the reply but my intention was to remove the time component
- not just keep it from appearing on screen. Also I wanted to do it
with VBA so that this will happen at the click of a button. So, like I
posted before, the INT() function serves my purpose better. Thanks for
your time though.

Regards,
Kirubakaran.
 
Back
Top