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?. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format in code
msg( Format(arrVal(0),"dd-mmm-yyyy") & " exists already")
-- Kind regards, Niek Otten "TUNGANA KURMA RAJU" wrote in message ... 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?. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format in code
Thanks ,Its working.
"Niek Otten" wrote: msg( Format(arrVal(0),"dd-mmm-yyyy") & " exists already") -- Kind regards, Niek Otten "TUNGANA KURMA RAJU" wrote in message ... 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?. |
Reply |
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) |