Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time format
Joe
Try With Date_Time .Value = Now() .NumberFormat = "MM/DD/YYYY hh:mm" End With Regards Peter Atherton "Joe Wildman" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |