date format in code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell Filling 2
if meet critertia then countif(a1:a10, between dates) 3
date functions 6
Load large files 6
dim 3
Date in wrong format 6
Date Format 2
Date Formatting 1

Back
Top