On Aug 10, 12:15*pm, jason wrote:
On Aug 10, 11:30*am, "Rick Rothstein"





wrote:
Since you posted to a programming newsgroup, I assume your question is
asking for a VB solution... use the Text property of the Range or Cells
objects to get the text that is in the cell instead of its underlying value.
For example, if A1 contains a date formatted as you indicated, then this
will copy the displayed text into the cell B1...

Range("B1").Valued = Range("A1").Text

--
Rick (MVP - Excel)

"jason" wrote in message

....

hello,

i need to copy a date formatted as "yyyymmdd" (preferably as a
string).
each time i copy it, i copy the mm/dd/yyyy format when i copy cells
(x,y).value or any other form.

any tips would be a huge help- Hide quoted text -

- Show quoted text -

exactly what i need.
thanks- Hide quoted text -

- Show quoted text -

actually not working.

code:
dim q
q=1
cells(2,2)=1
cells(3,2)=1
cells(4,3)=2009




Worksheets("Sheet1").Cells(5, q + 1) = Worksheets
("Sheet1").Cells(2, q + 1) & "/" & Worksheets("Sheet1").Cells(3, q +
1) & "/" & Worksheets("Sheet1").Cells(4, q + 1)
Worksheets("Sheet1").Cells(5, q + 1).NumberFormat = "m/d/
yy;@"
Worksheets("Sheet1").Cells(6, q + 1).Value = Worksheets
("Sheet1").Cells(5, q + 1).Text