View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
LHaro LHaro is offline
external usenet poster
 
Posts: 10
Default removing date from field

Thank U so much!

"Ron de Bruin" wrote:

Hi

Try this

Int(ActiveCell.Value)



--
Regards Ron de Bruin
http://www.rondebruin.nl


"LHaro" wrote in message ...
Hello -

I have a field that has both the date and the time in it, but what vba code
can i use to extract the date only? Thanks in advance to anyone who can help
me.