| 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 |
| 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) | |||
Threaded Mode
