D
David
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?
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?