ExcelBanter - Convert number to date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert number to date (https://www.excelbanter.com/excel-discussion-misc-queries/114756-convert-number-date.html)

Box666

Convert number to date

I have a field that shows as 200404 (format General) which I would like
to show as Apr2004, I have tried changeing the format to date mmyyy,
but that shows up as Sept 48 .

I feel sure this must be an easy (and often used ) procedure, can any
body advise me how best to do it please

Bob

Jim Thomlinson

Convert number to date

Try this formula...

=DATE(LEFT(A1, 4), MID(A1, 5,2), 1)
Where 200404 is in Cell A1
--
HTH...

Jim Thomlinson

"Box666" wrote:

I have a field that shows as 200404 (format General) which I would like
to show as Apr2004, I have tried changeing the format to date mmyyy,
but that shows up as Sept 48 .

I feel sure this must be an easy (and often used ) procedure, can any
body advise me how best to do it please

Bob

vezerid

Convert number to date

=TEXT(DATE(1900,--RIGHT(A2,2),1),"Mmm")&LEFT(A2,4)

HTH
Kostis Vezerides

Box666 wrote:
I have a field that shows as 200404 (format General) which I would like
to show as Apr2004, I have tried changeing the format to date mmyyy,
but that shows up as Sept 48 .

I feel sure this must be an easy (and often used ) procedure, can any
body advise me how best to do it please

Bob

All times are GMT +1. The time now is 04:13 AM.