| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenting dates showing m/d instead of m/d/y
I have a program that finds rolling 1 - 30 aged data.
The heading has 1 - 30 above that I would like to put the dates, such as 1/18 - 2/17 The below subroutine does that except the dates show the year also. Any ideas on how to have it show what I want. Thanks Don Sub concatenate() Range("A12").NumberFormat = "m/d" Range("a16") = Range("A12") & " - " & Range("B12") Range("A16").NumberFormat = "m/d" End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
concatenting dates showing m/d instead of m/d/y
Look at:
Sub Macro1() Range("H1").Value = Application.Text(Range("F1").Value, "m/d;@") & "-" & Application.Text(Range("G1").Value, "m/d;@") End Sub with dates in F1 and G1 -- Gary''s Student "don" wrote: I have a program that finds rolling 1 - 30 aged data. The heading has 1 - 30 above that I would like to put the dates, such as 1/18 - 2/17 The below subroutine does that except the dates show the year also. Any ideas on how to have it show what I want. Thanks Don Sub concatenate() Range("A12").NumberFormat = "m/d" Range("a16") = Range("A12") & " - " & Range("B12") Range("A16").NumberFormat = "m/d" End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
concatenting dates showing m/d instead of m/d/y
On Fri, 17 Feb 2006 18:34:50 -0800, don wrote:
I have a program that finds rolling 1 - 30 aged data. The heading has 1 - 30 above that I would like to put the dates, such as 1/18 - 2/17 The below subroutine does that except the dates show the year also. Any ideas on how to have it show what I want. Thanks Don Sub concatenate() Range("A12").NumberFormat = "m/d" Range("a16") = Range("A12") & " - " & Range("B12") Range("A16").NumberFormat = "m/d" End Sub Sub concatenate() Range("a16") = Format(Range("A12"), "m/d") & _ " - " & Format(Range("B12"), "m/d") End Sub --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates in fomula showing as whole number | New Users to Excel | |||
| how do I look for cells showing dates less than a certain date? | Excel Worksheet Functions | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| Dates showing are not what I type | New Users to Excel | |||
| Combo Box Showing numbers not dates | Excel Discussion (Misc queries) | |||
Linear Mode
