Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format in code
if e.offset(1,0)=arrVal(0) then
msg( arrVal(0) & " exists already") In the above code arrVal(0) is a date I am getting it in message box as 12/5/2005. I want this as 05-DEC-2005.What additional lines I ahve to insert to get the result what I need?. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
Customized Date Format | Excel Worksheet Functions | |||
Change case...help please | Excel Worksheet Functions | |||
format date in excel | Excel Discussion (Misc queries) | |||
Why Does Date Format Change on Chart | Excel Discussion (Misc queries) |