| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro is pulling wrong date format into Email
Hello, I have a macro that is pulling the time from a cell, into the message
body of an email in Outlook. But, it is not pulling the time...it's pulling the raw form. Example: Time should be: 10:00 AM Pulling into the message body: 0.416666666666667 Something I'm doing wrong? Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200810/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro is pulling wrong date format into Email
try something like this
format(range("A1"),"hh:mmAM/PM") -- Gary "Gina_28 via OfficeKB.com" <u46866@uwe wrote in message news:8bafb7f1b2679@uwe... Hello, I have a macro that is pulling the time from a cell, into the message body of an email in Outlook. But, it is not pulling the time...it's pulling the raw form. Example: Time should be: 10:00 AM Pulling into the message body: 0.416666666666667 Something I'm doing wrong? Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200810/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| from date format convert to text format is wrong | Excel Discussion (Misc queries) | |||
| date in wrong format | New Users to Excel | |||
| Strange? VBA code returns wrong date format (not a date) | Excel Programming | |||
| importing txt file and wrong date format... MACRO vs MANUAL | Excel Programming | |||
| Macro gives the wrong date format | Excel Programming | |||
Linear Mode
