Convert number to date

  • Thread starter Thread starter Box666
  • Start date Start date
B

Box666

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
 
Try this formula...

=DATE(LEFT(A1, 4), MID(A1, 5,2), 1)
Where 200404 is in Cell A1
 
=TEXT(DATE(1900,--RIGHT(A2,2),1),"Mmm")&LEFT(A2,4)

HTH
Kostis Vezerides
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert date to Age 3
Numbers showing Up Centered in Cell ? 1
Convert number to date value 8
Copying Dates 1
Converting general text format to date 6
Date and If problem 6
converting date to text 2
Remove date format? 3

Back
Top