| 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) | |||
Linear Mode
