Date Format

Hi,
I have some code that does some stuff pretty well, but I am trying to get a cell to have the value of a couple of cells and a varible, this line of code....

 WS4.Range("A2") = WS1.Range("C2") & " to " & Cust & " del " & WS1.Range("E2").Value

works fine in as much as it places the the three values I want into the correct cell but the date part, "(& WS1.Range("E2").Value)" is formatted as dd/mm/yyyy, and I want dd/mmm.
I have been trying for a while now, to no avail.
As always any help is much appreciated.
Thanks
LVL 1
Stephen ByromWarehouse/ShippingAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Shanan212Connect With a Mentor Commented:
 WS4.Range("A2") = WS1.Range("C2") & " to " & Cust & " del " & Format(WS1.Range("E2").Value, "dd/mmm")

Open in new window


 try this
0
 
Stephen ByromWarehouse/ShippingAuthor Commented:
Brilliant!!
Thanks a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.