Thread: Time format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Wildman[_2_] Joe Wildman[_2_] is offline
external usenet poster
 
Posts: 30
Default Time format

Hello everyone, I am unable to get the code right
I have a cell in VBA called "date_time", it is formated to be "mm/dd/yyyy
HH:MM"

In the output email it paste into it shows the the seconds so i did some
code and was unable to get it to work in the correct format

Call Date_Time (works) but shows seconds
or
Call Date_Time .... "mm/dd/yyyy HH:MM") ...not working