Thread: Date Display
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Patty Patty is offline
external usenet poster
 
Posts: 45
Default 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