Solved

Date Format

Posted on 2013-06-21
2
302 Views
Last Modified: 2013-06-21
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
0
Comment
Question by:Stephen Byrom
2 Comments
 
LVL 13

Accepted Solution

by:
Shanan212 earned 500 total points
ID: 39267113
 WS4.Range("A2") = WS1.Range("C2") & " to " & Cust & " del " & Format(WS1.Range("E2").Value, "dd/mmm")

Open in new window


 try this
0
 
LVL 1

Author Closing Comment

by:Stephen Byrom
ID: 39267524
Brilliant!!
Thanks a lot
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now