| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
user to input date as "yyyy" in cell
I have a time series chart feeding off user input data. The data and chart
are dates (eg: 01/01/2007 00:00:00) displayed as years (eg: 2007). I need the chart x-axis to remain as a time series. The user perceives that the cell contains "2007". Is there a way to enter just "2007" (4 characters only) and obtain a date/time for the year 2007 in a cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? | Excel Programming | |||
| Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
| Using "dd/mm/yyyy h:mm" on Date Variables | Excel Programming | |||
| Option Explicit and Date Format "dd mmm yyyy"? | Excel Programming | |||
| How To: Use Cell("Format") to return MMMM YYYY instead of D3 | Excel Programming | |||
Threaded Mode
