auto change 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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
R

RagDyer

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
 
T

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top