Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Display
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Display
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Display
If it is only for display and not for any calculations whatsoever you can
use a custom format like 00\/00\/0000 and it will display as you want if you really want a date that Excel will read as a date you would need either a help cell with a formula like =--TEXT(A1,"00\/00\/0000") then format that cell as a regular date or you can use an event macro http://www.cpearson.com/excel/DateTimeEntry.htm -- Regards, Peo Sjoblom "Patty" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Display
It is a language available to Excel to allow automation of steps you do
manually. For example: Private Sub Worksheet_Change(ByVal Target As Range) Set t = Target Set r = Range("A1") If Intersect(t, r) Is Nothing Then Exit Sub v = t.Text Dim d As Date d = DateSerial(Right(v, 4), Left(v, 2), Mid(v, 3, 2)) Application.EnableEvents = False r.Value = d Application.EnableEvents = True will wait until you enter the number in A1 and then change it to a date. This way only one cell is used, not two. -- Gary''s Student - gsnu200756 "Patty" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Display Date n-Workdays from a Certain Date | Excel Discussion (Misc queries) | |||
display date | New Users to Excel | |||
date display | Excel Discussion (Misc queries) | |||
X axis date - display beyond latest date. | Charts and Charting in Excel | |||
Date display | Excel Discussion (Misc queries) |