Thread: removing date from field
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default removing date from field
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.


Reply With QuoteReply With Quote