Date Display
What is VBA?
"Gary''s Student" wrote:
You can use another cell:
=DATE(RIGHT(D23,4),LEFT(D23,2),MID(D23,3,2))
or you can use VBA to do the same thing in a single cell.
--
Gary''s Student - gsnu200756
"Patty" wrote:
How can I configure a cell so that I can enter 11152007 as a date and have it
display as 11/15/2007?
Thanks,
patty
|