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