auto change date

  • Thread starter Thread starter toby
  • Start date Start date
T

toby

if i 've a column of data with month data in numeric forms (ie. 01, 02, 03,
04, 05..... ), is it possible for me to make them change to month in words
automatically?
so that 01 -> jan; 02-> feb and so on.!

thank you in advance
TOby
 
Hi Toby!

One way:

=TEXT(A1*29,"mmm")
This takes advantage of the fact that the date serial numbers n*29 are
in consecutive months in the year 1900 as long as n does not exceed 12

Or

=CHOOSE(A1,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct"
,"nov","dec")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Do I understand you to say that your data is a true date with this format;
01/05/2004
02/05/2004

If that be the case, then simply custom format to:
mmm/dd/yyy

To display:
Jan/05/2004
Feb/05/2004

If I misunderstood you, post back with additional info.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


if i 've a column of data with month data in numeric forms (ie. 01, 02, 03,
04, 05..... ), is it possible for me to make them change to month in words
automatically?
so that 01 -> jan; 02-> feb and so on.!

thank you in advance
TOby
 
thanks norman.
i made it.


Norman Harker said:
Hi Toby!

One way:

=TEXT(A1*29,"mmm")
This takes advantage of the fact that the date serial numbers n*29 are
in consecutive months in the year 1900 as long as n does not exceed 12

Or

=CHOOSE(A1,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct"
,"nov","dec")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Hi Toby!

Thanks for thanks is always appreciated. Which solution you used is
always useful for Google searchers.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top