Removing time from a date field

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
 
K

kulalosai

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.
 
Top