Date to Text

  • Thread starter Thread starter booshi
  • Start date Start date
B

booshi

Please advise how to copy a column of the following date format as text
into another column.

Selection.NumberFormatLocal = "yyyy-mm"

eg Instead of 2003-0,1 4-Jan-2003 returns to 37625
 
Hi Booshi,

Try:

Set srcRng = Range("A1:A10")
Set destRng = Range("D1")

srcRng.Copy destRng
destRng.Resize(srcRng.Count).NumberFormat = "0"
 
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

How to prevent change Numeric value to date format ? 3
Convert 24/03/2010 date into 03/24/2010 date format 3
Date format Workbooks Open 1
convert date 1
date corruption? 00/01/1900 1
Look up 6
VBA: Copy a date and paste as text 4
Different Date formats in text to be recognised as date value 8

Back
Top