Date Formatting/adding slashes
You can't just "add the slashes".
You must first get Excel to recognize as a date.
Assume 7132007 is in A2 enter in B2
=DATE(VALUE(RIGHT(A2,4)), VALUE(LEFT(A2,1)), VALUE(MID(A2,2,2)))
Returns July 13, 2007.
Format to m/dd/yyyy
Gord Dibben MS Excel MVP
On Fri, 11 Apr 2008 11:42:00 -0700, teresa
wrote:
Hello,
I have a spreadsheet with data from a datebase that list dates with no
slashes. How can I add slashes?
Current format -7132007
Desired format- 7/13/2007
Thanks
|